Registered aircraft · 603

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:89-02-10-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:89-02-10-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:89-02-10-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:89-02-10-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:89-02-10-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:89-02-10-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.

N800PAVance And Priscilla Hinton LLC · New Braunfels, TXS/N NA0438 N800RGRm13 Air LLC · Wellington, FLBuilt 1993 · S/N 258230 N800SEDodson International Parts Inc · Rantoul, KSS/N NA0425 N800SVAircraft Fidelity Corp Trustee · Dover, DES/N NA0470 N800VRCkv Express LLC · Minneapolis, MNBuilt 1984 · S/N 258016 N800WAKmwflight LLC · Wilmington, DEBuilt 1988 · S/N NA0414 N800WHGsmh LLC · Daniel Island, SCS/N 258080 N801LMGlobal Aircraft Solutions LLC Trustee · San Antonio, TXBuilt 1988 · S/N NA0409 N801PJGovoa LLC · Miami Beach, FLBuilt 1990 · S/N NA0456 N801RMBlue Skies Hawker LLC · Canton, MIBuilt 1984 · S/N 258011 N802WJXoom Enterprises LLC · Sunny Isles Beach, FLBuilt 1984 · S/N 258008 N803RKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 258003 N805ALScashley Falcon LLC · Portland, MEBuilt 1988 · S/N 35 N805FTG4sp Blackbox Holdings LLC · North Palm Beach, FLBuilt 1999 · S/N 1374 N807MMPollard Spares LLC · Fort Worth, TXBuilt 1983 · S/N 3014 N808CFBoss 8 LLC · Fort Worth, TXBuilt 1991 · S/N 1176 N808MFCd 321 LLC · Cypress, TXBuilt 2001 · S/N 1448 N80QJRegistered aircraftBuilt 1998 · S/N 1333 N810TMNomad Air LLC · Dover, DEBuilt 2002 · S/N 1483 N812PMEl Jefe Express II LLC · Lake Forest, ILS/N 127 N814NANasa Neil A Armstrong Flight Research Center · Edwards, CAS/N 1199 N815DTAviation Development Group LLC · Kalispell, MTS/N 1085 N816SPJmd Aviation LLC · Jupiter, FLBuilt 2001 · S/N 1452 N818MECape Clear LLC · Westboro, MABuilt 2000 · S/N 1431 N819VDAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 2004 · S/N 1535 N81HMIheart Media Management Services Inc · New York, NYBuilt 2000 · S/N 183 N821MPLucas Aviation LLC · Fremont, MIBuilt 1985 · S/N 258043 N824DHPollard Spares LLC · Roanoke, TXBuilt 1985 · S/N 3047 N824SMeregrass Inc · Dublin, TXBuilt 1987 · S/N 23 N825CPPilgrim Air 2 LLC · Van Nuys, CABuilt 1999 · S/N 1378 N826RPTbf Group Aviation LLC · Great Neck, NYBuilt 2003 · S/N 1507 N827GAPpg Industries Inc · West Mifflin, PABuilt 1999 · S/N 1391 N82BULacore Adventures LLC · Melissa, TXBuilt 1988 · S/N 51 N840ERTikchik LLC · Anchorage, AKBuilt 1988 · S/N 1049 N842PAValiair Ltd Co Trustee · Casper, WYBuilt 1988 · S/N 1057 N850RTFlying Owl Aviation LLC · Lewisville, TXBuilt 1997 · S/N 1324 N852SPStephens Pipe & Steel LLC · Jamestown, KYBuilt 1997 · S/N 1309 N855MWMunguia Mario · Downey, CABuilt 1993 · S/N 258241 N857STSeminole Tribe Of Florida · Hollywood, FLBuilt 1998 · S/N 1345 N85GC4lions LLC · Chula Vista, CABuilt 1991 · S/N 1161 N85WDAerovision-Logos Aircraft Holdings Vii Corp · Dover, DEBuilt 1987 · S/N 1008 N869MDEmo Systems LLC · Wilton Manors, FLBuilt 1999 · S/N 1363 N869SCPerennial Investments Inc · Anaheim, CABuilt 1994 · S/N 1236 N86MSAb Jet Co II LLC · Metairie, LABuilt 2000 · S/N 1406 N874CTrans-Exec Air Service Inc · Van Nuys, CABuilt 1993 · S/N 1219 N874VTGolden Goat LLC · Southern Pines, NCBuilt 1997 · S/N 161 N876GLGlj Aviation LLC · Pompano Beach, FLBuilt 2001 · S/N 1454 N877AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2001 · S/N 1461 N877LCLetica Leasing LLC · Rochester Hills, MIBuilt 1991 · S/N 1165 N878SMWorld Heir Inc · College Park, GABuilt 1997 · S/N 1319

Back to AD 89-02-10 R1