Skip to content

Registered aircraft · 7,857

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.

N3613FCentral California Soaring Association Inc · Avenal, CABuilt 1980 · S/N 556 N36144Grissom Timothy G · West Liberty, OHBuilt 1989 · S/N S60A-3126 N36148Sky Sailing Inc · Warner Springs, CABuilt 1980 · S/N 3 N3614BMaxon Stuart B · Los Lunas, NMBuilt 1980 · S/N 565 N3614NIngs Deborah · Centennial, COBuilt 1980 · S/N 2 N36156Moos Milton H Trustee · Westerville, OHS/N 5 N3615BDifco Leasing LLC · Newark, DEBuilt 1980 · S/N 4 N36166Grecco Joseph J · Saddle Brook, NJBuilt 1981 · S/N 10 N3616FWengair LLC · Powell, WYBuilt 1980 · S/N 7 N3616GArizona Soaring Inc · Maricopa, AZBuilt 1980 · S/N 8 N3616QSkibinski James · Senoia, GABuilt 1981 · S/N 567 N3617BCentral Pennsylvania Soaring Association Inc · Lemont, PABuilt 1981 · S/N 11 N3617DShortridge Randall A · Mesa, AZBuilt 1981 · S/N 14 N3617ETampa Bay Soaring Society Inc · Zephyrhills, FLS/N 16 N3617QCermack Michael W · Quartz Hill, CABuilt 1981 · S/N 17 N36183Kendallville Soaring Club Inc · Kendallville, INBuilt 1981 · S/N 25 N3618DAndrew Ross F · Woods Cross, UTBuilt 1981 · S/N 24 N3619BLeggett David R · Bangor, PABuilt 1981 · S/N 26 N3619GSchrepple Edward W · Shamong, NJS/N 27 N3619PKraemer Richard A · Hollywood, FLBuilt 1981 · S/N 28 N3619UWinsor Wyant W · Tehachapi, CABuilt 1981 · S/N 29 N361BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008703 N361KSBarrett Jane T · Tehachapi, CABuilt 1984 · S/N 21224 N36204K & L Soaring LLC · Cayuta, NYS/N 35 N3620EHarris Hill Soaring Corp · Elmira, NYBuilt 1981 · S/N 100 N3620TNevada Soaring Association Inc · Reno, NVBuilt 1981 · S/N 32 N3621BTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1981 · S/N 36 N3621GSimpkins Haskell · Cincinnati, OHBuilt 1981 · S/N 37 N3621TButler Thomas K · Austin, TXBuilt 1981 · S/N 40 N3622BHoran W Gareth · Glenside, PABuilt 1982 · S/N 41 N3622FWanagel Walter · Lisbon, CTS/N 3175 N3622WSuperior Soaring LLC · Scottsdale, AZS/N 43 N3625SCooper William C Jr · Delhi, LABuilt 1990 · S/N RX8-3042 N362BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008704 N36325Braden Richard Morgan · Lake Havasu City, AZBuilt 2016 · S/N 90/153 N3633YCarpenter David A · Stoddard, WIBuilt 1989 · S/N RX8-3047 N3635UJames Russell D · Orland, CABuilt 1989 · S/N S57A-3091 N3636ZSproul Keith A · North Brunswick, NJBuilt 1989 · S/N S57A-3077 N3637YMahoney Kade J · Eaton, COBuilt 1984 · S/N F7-175 N3639XRichardson Sean M · Kannapolis, NCBuilt 1990 · S/N RX83058 N363BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008705 N363KSBeta Fleet LLC · South Burlington, VTBuilt 1984 · S/N 21228 N363PWiederkehr Anthony C · Arlington, WAFirst renewal noticeBuilt 1969 · S/N 059 N363PCChristy Penelope M · Middletown, CTBuilt 2003 · S/N 6350 N36426Dzilinski Gene S · Lehigh Acres, FLBuilt 1991 · S/N S60A-3153 N36467Thum Kevin · Colorado Springs, COBuilt 1990 · S/N RX8-3063 N3647ASowers William H · Santa Rosa, CAFirst renewal noticeS/N RX8-3064 N3647BPratt Thomas V · Rancho Cucamonga, CABuilt 1990 · S/N RX8-3065 N364BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008706 N364VBramley Adam P · Albuquerque, NMBuilt 2019 · S/N 6896