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.

N9116MChurchman Harrison · Mcdonough, GAS/N RX9-3013 N9117NSmith Jo E · Arkport, NYBuilt 1993 · S/N S49A-3177 N9118Donica Leldon H · Marana, AZBuilt 1968 · S/N LS-1 N9118XMellon Sam A III · Oxford, ALBuilt 1993 · S/N RX8-3176 N9119NForden Noah · Saunderstown, RIBuilt 1993 · S/N S52A-3009 N911ATW I F A (Washington International Flight Acad) LLC · Gaithersburg, MDS/N 17275869 N911FCavanagh Michael B · Dubois, WYBuilt 1982 · S/N 64 N911HGunnarsson Jon · Concrete, WABuilt 1991 · S/N 917911 N911LERed Line Flyers LLC · Zionsville, INBuilt 2024 · S/N 2305 N911PEIrwin Patrick S · Lovelock, NVBuilt 2021 · S/N 1854 N911RCShamo Shelena · Orem, UTBuilt 2011 · S/N 6618 N91201Lambert Steve · Daytona Beach, FLFirst renewal noticeBuilt 1993 · S/N RXS8-3032 N9121KJohnson Robb C · Council Bluffs, IABuilt 1998 · S/N RX7-3325 N9122BBowling David C · Colorado Springs, COBuilt 1998 · S/N RX8-3308 N9123SCaswell Richard E · Eighty Four, PABuilt 1994 · S/N RX8-3172 N9123UWind Dancer Promotions Inc · Canton, MSBuilt 1998 · S/N RX8-3309 N9124JDrennan Benjamin B · Cordele, GAS/N S55A-3077 N91253Bb Aero Works Ltd · Whitehouse, OHBuilt 1993 · S/N RX8-3178 N9125SDegraff Trudy Ann · Corrales, NMBuilt 1998 · S/N S53A-3049 N91265Cole Joseph W · Town Creek, ALS/N RX8-3180 N9126BDcg & Associates Inc · Rio Rancho, NMBuilt 1994 · S/N RX8-3179 N9126KSee Glenn M · Albuquerque, NMBuilt 1998 · S/N RX7-3326 N91274Clayton Harry L · Wichita, KSS/N 8433-SH N9128CRegistered aircraftBuilt 1998 · S/N RX8-3311 N91297Swinton Robert A · Queensbury, NYS/N S60H-3007 N912BBrokenstraw Flyers · Pittsfield, PABuilt 1992 · S/N 917912 N912CPHoppe Gregory M · Big Lake, AKS/N 165 N912HDLawhorn Richard G · Louisville, KYBuilt 1995 · S/N 269 N912TWGriffin David R · Frisco, TXBuilt 2023 · S/N 2223 N9130FAkins Rocky D · Cedar Hill, MOBuilt 1993 · S/N S57A-3152 N9130QCuadrado R · Miami, FLBuilt 1994 · S/N RXS8-3040 N9132Jones Gary N · Diamondhead, MSBuilt 2004 · S/N 5251 N9132ZMcvay Gilbert L · Trenton, MOBuilt 1993 · S/N S49A-3180 N91339Forrest Services LLC · Dayton, NVBuilt 1998 · S/N S60A-3251 N91345Hood River Soaring Inc · Hood River, ORBuilt 1978 · S/N 20630 N9134ZSpirit Ballooning LLC · Canaan, CTBuilt 1996 · S/N 94 N91355Camelot Balloons Inc · Basalt, COBuilt 1998 · S/N S71A-3020 N9136FKeating Lawrence A · Newark, DES/N 1814 N9136JFogle Timothy Jay · Elko, NVBuilt 1998 · S/N RX8-3280 N9136YHoyt Robert M · Rogers, ARS/N 060 N9138YLedger Holly S · Keithville, LABuilt 1998 · S/N S53A-3050 N9139ECato Amie D · Commerce, TXBuilt 2007 · S/N RX7-3348 N9139VPrairie Sky Inc · Custer, SDBuilt 1998 · S/N RX7-3329 N913GMarshall Soaring Club · Marshall, MIBuilt 1982 · S/N 3748 N913JHFlying Chicken LLC · Colorado Springs, COS/N 140 N913PRPortland Rose Balloons LLC · Wilsonville, ORBuilt 2023 · S/N 2117 N9141HOdom Gary Eure · Valparaiso, FLBuilt 1994 · S/N S52A-3012 N91436Michael Matthew C · Ames, IAS/N 34 N91443Aero Force Balloons LLC · Simpsonville, KYBuilt 1998 · S/N S57A-3204 N9145FEichhorn David J · Corrales, NMBuilt 1998 · S/N S53A-3054