Skip to content

Registered aircraft · 1,752

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
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.

N1456XYoung Daniel J · Cedarburg, WIBuilt 1975 · S/N 28R-7535286 N1468THindle John Charles IV · Whitehouse Station, NJBuilt 1972 · S/N 28R-7235296 N1469TThree Wing Flight School LLC · Stratford, CTBuilt 1972 · S/N 28R-7235297 N1472TGreen Lakes Aviation LLC · Belton, SCBuilt 1972 · S/N 28R-7235298 N1479TWnc Aviation LLC · Arden, NCBuilt 1972 · S/N 28R-7235302 N147LHSchool Board Of Brevard County Florida · Melbourne, FLBuilt 2003 · S/N 2844103 N1481XBadgerland Aero Club Inc · Fitchburg, WIBuilt 1975 · S/N 28R-7535289 N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290 N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291 N1492TLargo Logistics LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235305 N1498TMurwin Keith T · Douglasville, GABuilt 1972 · S/N 28R-7235307 N149DTNew Mexico Flying Eagle Inc DBA · Tucson, AZBuilt 2005 · S/N 2844125 N149JLKenyon Terry J · Henderson, ARBuilt 1975 · S/N 28R-7535109 N15006Corio Salvatore J Jr · Warwick, RIBuilt 1972 · S/N 28R-7235315 N15007Marshall County Flying Club Inc · Lacon, ILBuilt 1972 · S/N 28R-7235316 N15013Krantz Gwendolyn A · Advance, NCBuilt 1972 · S/N 28R-7235318 N15021Brandywine Flight School · West Chester, PABuilt 1972 · S/N 28R-7235319 N15022Registration Pending · Riverside, CARegistration pendingBuilt 1972 · S/N 28R-7335001 N15027Mallue Jeff · Springboro, OHBuilt 1972 · S/N 28R-7235320 N1504XVerge Aeronautics LLC · Charlotte, NCBuilt 1975 · S/N 28R-7535301 N1505XFarrell Donald A · Owasso, OKBuilt 1975 · S/N 28R-7535302 N1508TWalker Jereme · Durham, NCBuilt 1972 · S/N 28R-7235308 N1510XSedlacek John · Pittstown, NJBuilt 1975 · S/N 28R-7535307 N15118Illinois Valley Flying Club Inc · Peru, ILBuilt 1972 · S/N 28R-7335023 N15125Mallozzi Michael A · Albuquerque, NMBuilt 1972 · S/N 28R-7335025 N1514XRabidou Gary R Jr · Lancaster, MABuilt 1975 · S/N 28R-7535305 N15151Smith Jared · Allendale, ILBuilt 1972 · S/N 28R-7335029 N1515TSussman Steven T · Goshen, NYBuilt 1972 · S/N 28R-7235311 N15169Stephens Brennan · Irving, TXBuilt 1972 · S/N 28R-7335032 N1517XDippolito Thaddeus M · Sherwood, ARBuilt 1975 · S/N 28R-7535306 N15191Lumpp John R · Old Brookville, NYBuilt 1972 · S/N 28R-7335033 N15207Tiburon Aviation LLC · Tampa, FLS/N 28R-7335037 N15226Blackwell Stephen E · Burlington, NCBuilt 1972 · S/N 28R-7335040 N15228Registered aircraftS/N 28R-7335039 N1522XSpayd Charles M · Indianapolis, INBuilt 1975 · S/N 28R-7535308 N15250Sedberry Jason A DBA · Kokomo, INS/N 28R-7335043 N15256Mms Aviation LLC · Chattanooga, TNBuilt 1972 · S/N 28R-7335044 N15270Thompson Ed R · Palm Springs, CABuilt 1972 · S/N 28R-7335012 N15289Story Aranzazu · Draper, UTBuilt 1972 · S/N 28R-7335046 N1530XQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 28R-7535312 N15313Beine Gilbert J · Campbellsport, WIBuilt 1972 · S/N 28R-7335049 N15324Lewis Christopher Dean · Bettendorf, IABuilt 1972 · S/N 28R-7335050 N15334Shuart Bruce E · Wantage, NJBuilt 1972 · S/N 28R-7335051 N15379Huyler John C · Shreveport, LABuilt 1972 · S/N 28R-7335053 N15380Miller Aviation Group LLC · Coon Rapids, MNBuilt 1972 · S/N 28R-7335054 N1538XStaton Justin · Kemah, TXBuilt 1975 · S/N 28R-7535315 N153ASBowen Arrow Aviation Inc · Albany, NYBuilt 1976 · S/N 28R-7635436 N15473Cerniglio Dominic Antonio · Sebastopol, CAS/N 28R-7335061 N1547XKoch Steven T II · Brownsburg, INBuilt 1975 · S/N 28R-7535321 N1550XVictors Vectors LLC · Valparaiso, INS/N 28R-7535323

Back to AD 81-11-02 R1