Registered aircraft · 744

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:80-09-03-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:80-09-03-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:80-09-03-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:80-09-03-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:80-09-03-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:80-09-03-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.

N49JPSumner Properties LLC · Somersworth, NHBuilt 1990 · S/N LJ1243 N49KCBeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB-318 N49LLSilver Wing Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB-843 N49RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BD02 N500CRElite Medical Air Transport LLC · El Paso, TXBuilt 1980 · S/N BB-714 N500EQTxsd Holdings LLC · Amarillo, TXBuilt 1994 · S/N LJ-1387 N501EBPrecision Holdings LLC · Kimberly, IDBuilt 1978 · S/N BB-422 N501HKBam Aviation LLC · Baton Rouge, LABuilt 1979 · S/N BB-565 N501MSDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N LJ-626 N502APJbjp Capital Holdings LLC · Newark, DEBuilt 1984 · S/N BB-1187 N503CBCtb Inc · Goshen, INBuilt 1982 · S/N LJ-997 N503JMDls Aviation LLC · Gilmer, TXBuilt 1980 · S/N BB-712 N503PWellsprings Aviation LLC · Winston Salem, NCBuilt 1979 · S/N BB-437 N503RMKa200 LLC · Jacksonville, NCBuilt 1980 · S/N BB-673 N504CBPlane Leasing LLC · Wilmington, DEBuilt 1974 · S/N LW-125 N504ECAlpha Tango LLC · Little River, SCBuilt 1995 · S/N BE-120 N505MWBoeing Co · Renton, WAS/N LW-155 N506AFCreedeair LLC · San Antonio, TXBuilt 1979 · S/N LJ-843 N507BEM P Leasing LLC · Vermillion, MNBuilt 1980 · S/N BB-735 N50EDynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BL7 N50EBDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-128 N5111PDe La Vega Artemio · Dallas, TXBuilt 1986 · S/N LJ-1136 N511DPAir Med Services LLC · Lafayette, LABuilt 1981 · S/N BL-15 N511WMD&D Industries Inc · Monclova, OHBuilt 1973 · S/N LW-57 N515GKAvintel Management LLC · Dublin, OHBuilt 1974 · S/N LW-108 N519DBN519db LLC · Dover, DEBuilt 1978 · S/N BB-436 N519RRCgs 2003 LLC · San Leon, TXBuilt 1978 · S/N BE-40 N51DNDjl Investments LLC · Gilroy, CABuilt 1972 · S/N LW-7 N520DDThomas Asset Group Ltd · Springtown, TXBuilt 1980 · S/N BB-738 N520MCBedrock LLC · Anniston, ALBuilt 1975 · S/N BB-43 N521FTR & G Aviation LLC · Hazlehurst, GABuilt 1980 · S/N BL-012 N522MJPpr2 Inc · Jackson, MSS/N LW-80 N524MRMt King Air · Stevensville, MTBuilt 1979 · S/N BB524 N52KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-42 N52VSVista Strategies & Solutions Group LLC · Hendersonville, NCS/N LW-301 N531CBSpectre Aviation LLC · Dover, DEBuilt 1983 · S/N BE-133 N533SSMacon King Air 90 LLC · Dover, DEBuilt 1976 · S/N LW-197 N53BAIvester Drywall & Painting Inc · Salisbury, NCBuilt 1979 · S/N BB-426 N53CEEngineering And Mfg Svcs Inc · Huntsville, ALBuilt 1975 · S/N LW-160 N53ECBas Part Sales LLC · Greeley, COBuilt 1972 · S/N LJ552 N53HSC&B Aerial Transport Inc · Wilmington, DEBuilt 1976 · S/N LW-186 N53KADesert Mountain Air LLC · Kalispell, MTBuilt 1981 · S/N BB-880 N546CNCwn LLC · Wilmington, DEBuilt 1974 · S/N LJ609 N549BRCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N LJ-809 N54PTMccall Transport LLC · Portland, ORS/N LW-331 N54TKDlp Real Estate Capital Inc · Saint Augustine, FLBuilt 1980 · S/N BB-686 N54USSilver Eagle Express LLC · Orange, CABuilt 1981 · S/N BE122 N550GLGaba Zero Seven LLC · Beaumont, TXBuilt 1980 · S/N BB-781 N551JLN551jl LLC · Greenville, SCBuilt 1980 · S/N BB-788 N552BSBroken Arrow Crop Insurance Inc · Perryton, TXBuilt 1979 · S/N LJ-836

Back to AD 80-09-03 R1