Registered aircraft · 22,428

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N12757Altitude Aviation Group LLC · Christmas, FLBuilt 1965 · S/N 28-20776 N1276TShillieto Mark C · Wilmington, OHBuilt 1972 · S/N 28-7225393 N1278TSmith Sullivan · Cookeville, TNBuilt 1972 · S/N 28-7225447 N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077 N127GT7 Golf Tango LLC · Saint Petersburg, FLBuilt 2004 · S/N 3257343 N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503 N127MTPilotsplane LLC · Boca Raton, FLBuilt 2003 · S/N 2844094 N127VGEvans James F · Columbus, GABuilt 1978 · S/N 32R-7885274 N1280TCertified Equipment Inspections LLC · Washington, PABuilt 1972 · S/N 28R-7235253 N1284NAbnc Air LLC · Wellington, FLS/N 28-7405076 N1284WBethel Don G · Bossier City, LABuilt 1967 · S/N 28R-30304 N1286GRegistered aircraftS/N 28-7990076 N1286THeffelfinger Paul D · Seven Valleys, PABuilt 1972 · S/N 28-7205277 N1287TBelle Casa Aero LLC · Tarpon Springs, FLBuilt 1972 · S/N 32-7240111 N1288HFly By Knight Inc · Hammond, LABuilt 1976 · S/N 28-7716011 N128AGarza Family LLC · Helena, MTBuilt 1967 · S/N 32-40354 N128DPGherebi Belaid A · San Diego, CAS/N 28-7125293 N128GRJaques Stanley S · Cassville, MOBuilt 1968 · S/N 28R-30806 N128HBSowle LLC · Tampa, FLBuilt 2007 · S/N 3257479 N128WPPatterson Weldon E · Maryville, TNBuilt 1969 · S/N 32-40579 N1290HWeiss Gregory K · Manitou Springs, COS/N 28-7716012 N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278 N1297HHop A Chopper Inc · Dover, DES/N 32-7700010 N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112 N129EWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 28R7335265 N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219 N129SAUnlimited Vertical LLC · Milton Freewater, ORS/N 28R-7737053 N129SCSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 32-7440057 N12ERPropelling The Gospel Missions Inc · Standish, MEBuilt 1976 · S/N 28-7615099 N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439 N12HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020131 N12PJLarrabee Joey S Trustee · Holyoke, COBuilt 1979 · S/N 28R-7931105 N12STWise Ventures LLC · Mooresville, NCBuilt 2006 · S/N 3257412 N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417 N1301UDonohue Thomas · Carmel, NYBuilt 1964 · S/N 28-20321 N1307HDileo Steven · Gallatin, TNS/N 28-7716015 N130BWPobiega Michael J · Fort Mill, SCBuilt 1970 · S/N 32-40963 N130DGDixie Aviation LLC · Pelham, ALBuilt 1972 · S/N 28R-7235127 N130GHBose Tamal · Tucson, AZBuilt 1965 · S/N 32-124 N130JMSalty Skies Aviation LLC · Van Nuys, CABuilt 1982 · S/N 28-8390036 N130KSouthern Aircraft Consultancy Inc Trustee · NorfolkRegistration ineffective or invalidBuilt 1978 · S/N 32R-7885109 N130RRAllbritten Jeffrey P · Winder, GAS/N 2841264 N130TLynch Machining LLC · North Vernon, INBuilt 2003 · S/N 2844104 N130XRM&A Adams Family Lp · Mckinney, TXS/N 32R-7887003 N1310KVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7790216 N1310UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020247 N1317HLightfoot Carl · Beaumont, TXS/N 28-7790304 N1317TWhite Tavon L · Stockbridge, GABuilt 1972 · S/N 28-7225461 N1318HEvern Properties LLC · Kalispell, MTS/N 28R-7703022 N1318TAire-Drifter LLC · Staten Island, NYS/N 28-7205280

Back to AD 87-08-08 R3