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.

N7423WWay Michael Charles · Garberville, CAS/N F7-256 N742TCMitchell David C · New Castle, INFirst renewal noticeBuilt 1992 · S/N 2291USA N743JFPanasuk Austin R · Sidney, MTS/N 419-74 N7446Bowe Walter C Trustee · Sonoma, CAS/N A-19 N7447MShipley Michael D · Gilbertsville, PABuilt 2014 · S/N 1088 N745CARegistration Pending · Dover, DERegistration pendingS/N 421C1043 N745LBKeener Jennifer S · Simpsonville, SCBuilt 2002 · S/N 5192 N7476Clayton Harry L · Wichita, KSBuilt 1968 · S/N 1660 N747KHAbell James M · Alameda, CABuilt 2002 · S/N 5201 N747LBRuppert Jason · Middletown, OHS/N 5438 N747VYamauchi Zacharyregistered · Truckee, CABuilt 1998 · S/N 11 N747WHJobb Investments Inc · San Angelo, TXBuilt 2015 · S/N 5587 N747XLSamson Philip C · Nashville, TNBuilt 1981 · S/N 20459 N7481Stoia James W · Wagener, SCBuilt 1957 · S/N 268 N7488JColeman Donald W · Medford, ORBuilt 1977 · S/N 43 N748LLDucharme Paul Q · Lafayette, LAS/N 121-42537 N7497White Sands Soaring Association · Alamogordo, NMBuilt 1977 · S/N 2004 N749DGEndeavor Aviation Inc · Belgrade, MTBuilt 2023 · S/N 6982 N749LBJtrzeb Lta LLC · Appleton, WIBuilt 2011 · S/N 5477 N749RDavids Daniel D · Woodinville, WAS/N 043 N74ASBegley Charlotte · Orlando, FLBuilt 1978 · S/N B-817 N74DGHollins James B · Waxahachie, TXBuilt 1977 · S/N 71 N74HBHunterdon Ballooning Inc · Lebanon, NJBuilt 2022 · S/N 6949 N74KHHoover Wayne C Jr · Lawrenceville, GABuilt 1985 · S/N 4511 N74PZBlount Trevor A · Spanish Fort, ALBuilt 2003 · S/N 65/122 N74RJEbenhack Thomas C · Tucson, AZBuilt 1979 · S/N 3357 N74RRKbi Leasing LLC · Phoenix, AZBuilt 2012 · S/N 5513 N74RSKuehlmuss Michael · Whately, MABuilt 1975 · S/N S55A-233 N74THardy John · Fort Worth, TXBuilt 1973 · S/N 1809 N74TKKinser Aviation LLC · Guthrie, OKBuilt 2023 · S/N LP2023-04 N74TNGallegos Frank L · Los Lunas, NMS/N S50A-231 N74WPVersatile Aviation LLC · Waterford, MIBuilt 1986 · S/N 6090 N7500GForrest Services LLC · Dayton, NVBuilt 2001 · S/N 5170 N7500YEmpty Pockets Ballloon Team LLC · Reno, NVBuilt 2001 · S/N 5169 N75017Airtime Balloon Co · Troutman, NCBuilt 2004 · S/N 5268 N7501GWindcraft LLC · Londonderry, VTBuilt 2002 · S/N 5202 N7501UDougherty Nicholas · Rio Rancho, NMBuilt 2002 · S/N 5206 N7502GZb Promotions LLC · Ashland, OHBuilt 2002 · S/N 5219 N7502QRed Baron Balloon Corps LLC · Lebanon, OHBuilt 2001 · S/N 5178 N75038Aerial Advantage Inc · Columbia, MOBuilt 2004 · S/N 5055 N7503EWoodward Jay DBA · Snohomish, WABuilt 1992 · S/N 5757 N7503GGreggerson Vernon L · El Paso, TXBuilt 2001 · S/N 5177 N7503JWalz Chuck L · Munith, MIBuilt 2003 · S/N 5220 N7503QPfeifer Holly J · Norwalk, IABuilt 2002 · S/N 5210 N7504DSouthern Arizona Balloon Excursions Inc · Tucson, AZBuilt 2002 · S/N 5193 N7504EBuesing Jeffrey · Colorado Springs, COBuilt 2002 · S/N 5213 N7504THeaven Bound Balloons LLC · Wright, MNBuilt 2002 · S/N 5214 N7504ZMid Pacific Aero Services LLC · Honolulu, HIS/N S1266 N7505HSpicer Todd A · Danville, ILBuilt 2001 · S/N 5172 N7505JBlair Ventures LLC · Newark, DEBuilt 1991 · S/N 5746