Skip to content

Registered aircraft · 7,850

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.

N124GBKennedy Thomas L Jr · Deltona, FLS/N 12006 N124GWReineke David C · Mahomet, ILBuilt 2016 · S/N 5604 N124HCTeichner Bruce A · Glen Allen, VAS/N 24256 N124MMSorenson Kenneth G · Waller, TXBuilt 1989 · S/N 24030 N124NMBlue Wall Soaring LLC · Wilmington, DEBuilt 2014 · S/N 040-MS N124SSHutnick Michael C Jr · Bloomsburg, PABuilt 1976 · S/N 1172 N124TPDoyle Patrick Hugh · Keller, TXBuilt 1999 · S/N 03020799 N1253DDerado John · Lebanon, INBuilt 2004 · S/N 6382 N1256RMidwest Ballooning Adventures Inc · Chicago, ILS/N 6423 N1259ZRegistered aircraftS/N 6436 N125CCSilverado Soaring Inc · Roseville, CABuilt 1982 · S/N 3710 N125JPPrimm Jim R · Roswell, NMBuilt 1986 · S/N A8603 N125KPPiper John · Pearl River, NYBuilt 2025 · S/N 12122014 N125MZMicke Thomas Bernd · Mansfield, MABuilt 2001 · S/N 005 N125PDe Koevend Enterprises Inc · Fort Garland, COBuilt 1984 · S/N S77A-111 N125PWTexas Soaring Association Inc · Midlothian, TXBuilt 1996 · S/N 1705025 N125SSRousselle Kenneth D · Loveland, COBuilt 1976 · S/N 1311 N125TXAirborne Engineering Dynamics LLC · Wilmington, DEBuilt 2000 · S/N 300.125 N1263Browning John · Blairstown, NJBuilt 1968 · S/N 78 N1266NByard Jeffery G · Carson City, NVBuilt 1968 · S/N 134 N1269PSaiz Joshua · Albuquerque, NMBuilt 2006 · S/N 6463 N126AOliver John F Trustee · Chula Vista, CAS/N 38 N126BWilkinson Ephriam B · Eads, TNBuilt 1964 · S/N 275 N126BAAnderson Austin R · Capitan, NMS/N 284 N126BVCollins Dennis L · Richland, WABuilt 1968 · S/N 422 N126CPHamilton Soaring Club Inc · Hamilton, TXBuilt 1974 · S/N 612 N126CRMhr Leasing LLC · Hickory Corners, MIS/N 649 N126DDungan Gregory David · Boca Raton, FLBuilt 1964 · S/N 81 N126DBBlack-Nixon C Dianne · Wayne, NJBuilt 1971 · S/N 516 N126EWilkinson Ephriam B · Eads, TNBuilt 1974 · S/N 608 N126ERHobbs Martin Lowell · Old Fort, NCBuilt 1955 · S/N 4 N126HDMahony Thomas Charles · Mcmurray, PABuilt 1974 · S/N 597 N126JGBrian Ofarrell Aviation Inc · Pembroke Pines, FLS/N 550470 N126LBWelch Tracy L · Lincoln, ILBuilt 2003 · S/N 5245 N126LEIsley Todd D · Carlisle, IABuilt 2012 · S/N 5499 N126LJHudson Peter O · Ridgecrest, CABuilt 1999 · S/N 046 N126LZHackstaff De Carrillo Karen L · Guanajuato GtoNon-citizen corporation, flight hours not reportedBuilt 1993 · S/N 5863 N126MDGrand Lake Air Ventures LLC · Celina, OHBuilt 1974 · S/N 599 N126MHSky Sailing Inc · Warner Springs, CABuilt 1973 · S/N 576 N126MNStanton Sport Aviation · Stanton, MNBuilt 1965 · S/N 319 N126RRRainbow Ryders Inc · Albuquerque, NMBuilt 2023 · S/N 5794 N126SBGeeson William · Yucca Valley, CABuilt 1998 · S/N 118 N126SFGrace Lance C · Alamogordo, NMBuilt 1974 · S/N 610 N126SGLowry Wilson R · Leonardtown, MDBuilt 1963 · S/N 102 N126SVCayton John A Sr · Ellabell, GABuilt 2002 · S/N 2002EN-AX6EXP N126TCEakes Benjamin V · Meridian, MSBuilt 1991 · S/N 1880USA N126TDOliver Thomas M · Littlefield, AZBuilt 1974 · S/N 596 N126WWilkinson Ephriam B · Eads, TNS/N 524 N126WESchwartz Ronald R · Blairstown, NJBuilt 1978 · S/N 680 N1271Brokenstraw Flyers · Pittsfield, PABuilt 1966 · S/N 1513