Skip to content

Registered aircraft · 7,858

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.

N427BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029009 N427BGAlbuquerque Soaring Club Inc · Albuquerque, NMBuilt 1982 · S/N 3739 N427CBCampbell Douglas J II · Pahrump, NVBuilt 2016 · S/N 6778 N427JDavenport Kira L · Malta, NYS/N 4095 N4280AWolfe Donald E · Notasulga, ALBuilt 1961 · S/N 1138 N4280CWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1964 · S/N 7155 N4281BNagel Wanda · Placerville, CABuilt 1978 · S/N 123 N428ARBoulet Mark · Billings, MTBuilt 2018 · S/N MAB2018003 N428BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029010 N428DAFall Darrin · Grass Lake, MIFirst renewal noticeBuilt 2020 · S/N 6909 N428RWWard Robert · Quakertown, PABuilt 2014 · S/N 1062 N4296CManeely Roy H · Wadsworth, OHBuilt 1965 · S/N 6403 N429BGCherryhill Flying Club LLC · Freetown, INBuilt 1982 · S/N 3737 N429BKBeeby Jonathan · Creve Coeur, MOBuilt 2001 · S/N 6290 N429FHAviation Dynamics LLC · Hastings, MNBuilt 2002 · S/N 10-12S12 N429SHMichalowski Roman · Eastchester, NYBuilt 2008 · S/N 29032 N429TCSale Reported · Marana, AZSale reportedS/N 2232USA N42CASoaring Society Of Boulder Inc · Boulder, COBuilt 1997 · S/N 239CS N42CGSummers Charles M · Rapid City, SDBuilt 1980 · S/N 119 N42DJHamilton Claude H III · Bonsall, CABuilt 2001 · S/N 8387 N42FRGewanter Alan B · Ottsville, PABuilt 1991 · S/N 44 N42JSOgden Christopher S · Chewelah, WAS/N 001 N42KXRegistered aircraftBuilt 2013 · S/N R-001 N42LSLs7 LLC · Elgin, ILS/N 7082 N42MEPeterkin Michael J · Johnson City, TNBuilt 2001 · S/N 3E493 N42NSWright Robert L · Albuquerque, NMBuilt 1981 · S/N 4082 N42RDGoold Arthur M · Chesterfield, INBuilt 1979 · S/N 42 N42RMMeeks Casey G · Brighton, COBuilt 1976 · S/N B-720 N42TCRegistration Pending · Loveland, OHRegistration pendingBuilt 1975 · S/N 447 N42UKDonegon Christopher P · Colorado Springs, COBuilt 2009 · S/N 6561 N42UMBroker William · Plano, TXBuilt 2013 · S/N 42/21 N42ZAStephenson Kevin L · Glendale, AZBuilt 2013 · S/N ZS-4201 N430BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029012 N430BBRegistered aircraftBuilt 2005 · S/N 18 N430CBSmith Cody · Fort Worth, TXBuilt 2023 · S/N 2172 N430CLSaucedo Robert A · Kingwood, TXBuilt 1976 · S/N 476 N430LBBuzzards Glory Balloon Co LLC · Cedar Rapids, IABuilt 2006 · S/N 5324 N430MState Of Louisiana · Baton Rouge, LAS/N 18268250 N430SRAirborne Ads LLC · Highland, MIBuilt 2020 · S/N 6900 N431BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029013 N431TCGolden Horizon Venutres LLC · Temecula, CAS/N 2244USA N4321DBailie William A · Saratoga Springs, UTBuilt 1978 · S/N 10 N432MSilberer Gabor Z · Parker, COBuilt 1977 · S/N 20512 N432RGAeronautical Solutions LLC · Taos, NMBuilt 2016 · S/N 6801 N433BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029014 N433BBGet High Inc · Longview, TXBuilt 2020 · S/N 5740 N433KBBarrett Dennis F · Temecula, CABuilt 2011 · S/N 874 N433TCPaddie Joe H · Longview, TXBuilt 1992 · S/N 2220USA N43495Radowski Johnathan P · Phoenix, AZBuilt 1997 · S/N 085 N434BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029011