Skip to content

Registered aircraft · 7,860

Aircraft with this engine in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('00000')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('00000')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N5555EPye Houston W · Cloudcroft, NMBuilt 1993 · S/N RX8-3157 N5555HJones Chris M · Amarillo, TXBuilt 1979 · S/N RX7-123 N5555THartshorn Sharon · Amarillo, TXFirst renewal noticeBuilt 2017 · S/N 1299 N5557NSchreiber-Beck Cynthia K · Wahpeton, NDBuilt 1979 · S/N RX6-346 N555ABKnerr Joshua D · Tehachapi, CABuilt 1992 · S/N 25041 N555AGGuay Mark W · Westfield, MABuilt 1977 · S/N 76 N555CFCarpenter Stanley H · Tifton, GABuilt 1974 · S/N 89 N555GFRobinson Erik S · Truckee, CABuilt 1984 · S/N 297 N555MWSky Soaring Inc · Hampshire, ILBuilt 1997 · S/N 17 07 020 N555PWTexas Soaring Association Inc · Midlothian, TXBuilt 1998 · S/N 17.11.001 N555WGLeonard Steven E · Wichita, KSBuilt 1979 · S/N 77 N555XXGreen Jim H · Seattle, WABuilt 1980 · S/N 03 N55611Marti Roy W · Naples, FLBuilt 1979 · S/N S55A-537 N5562KMinnetonka Balloon Co Inc · Chanhassen, MNBuilt 1979 · S/N S55A-539 N5562RKimmich Russ S · Coronado, CABuilt 1979 · S/N RX6-354 N5563KBluegrass Balloons LLC · Louisville, KYBuilt 1979 · S/N S45A-101 N5563LArman Marcelo A · San Diego, CAS/N S55A-554 N5563NKornfield Edward Alan · Anchorage, AKBuilt 1980 · S/N S50A-282 N5563VWille Chad C · Corning, IABuilt 1960 · S/N 1028 N55647Davis John C IV · Evergreen, COBuilt 1979 · S/N S40A-142 N5567Flesberg Allan J · Olathe, KSBuilt 1972 · S/N 317 N556JKKugler John · Mccook, NEBuilt 2014 · S/N 002 N556MGMarshall Jim G DBA · Sonoma, CABuilt 2014 · S/N 1047 N5572AJd Adventures LLC · Piscataway, NJBuilt 1979 · S/N S55A-559 N5575RBourdon David A Jr · Green Cove Springs, FLS/N 085 N5578AFargo Air Museum · Fargo, NDBuilt 1958 · S/N 376 N5578VWebb Robert H · Lancaster, CABuilt 1965 · S/N 38 N5589BBoland Brian J · Post Mills, VTBuilt 1980 · S/N 12 N5589TStanko Nicholas J DBA · Austin, TXS/N 318 N558CAScarpelli Peter J · The Villages, FLBuilt 2017 · S/N 29096 N558TFRomero David M · Santa Ynez, CAS/N 030606 N5594Above The Clouds Inc · Middletown, NYBuilt 2022 · S/N 1946 N5595LChapman Edward J · Jordan, MNBuilt 2011 · S/N 5482 N5596SPatton Bruce H · Independence, ORBuilt 1982 · S/N 138 N5597AKolberg Rocky · Kelso, WABuilt 1960 · S/N 846 N55BEPenultimate 210r LLC · Cumming, GAS/N P21000873 N55KGAustria Alfred N · San Jose, CAS/N 101A0200 N55PSBauer Douglas M · Pahrump, NVBuilt 1976 · S/N 64 N55SZHamilton James L III · Sparks, NVBuilt 1997 · S/N 551197096 N55YRArmstrong Gregory A · Bonita, CABuilt 1970 · S/N 79 N5602DSf27 LLC · Saint Augustine, FLBuilt 1967 · S/N 6074 N560BHPeak View Ballooning LLC · Albuquerque, NMBuilt 2016 · S/N 001 N560MNSinnen Stephen J · Shakopee, MNBuilt 2002 · S/N 001 N560RProkes William J · Tempe, AZBuilt 1987 · S/N 147 N560WOliver Balloons LLC · Bloomington, INBuilt 2004 · S/N 5250 N5610CSonoma Ballooning Adventures LLC · Sonoma, CABuilt 2011 · S/N 872 N561KBOhnemus Troy M · Carlisle, IABuilt 2023 · S/N 2129 N561MRArrowood William M · Albuquerque, NMBuilt 2023 · S/N 6977 N562JGGoebel James W · Loveland, OHBuilt 2016 · S/N 001 N5630Pavel Skrabal · Wood Dale, ILBuilt 1983 · S/N 258