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.

N190RLCamair Leasing LLC · Granbury, TXBuilt 1972 · S/N LW-1 N191JRLocke-Lane Aviation LLC · Statesville, NCBuilt 1975 · S/N LW144 N1926A1926a LLC · Auburn, ALBuilt 1981 · S/N BB-922 N199DWAeon62 Holdings LLC · Plano, TXBuilt 1980 · S/N LW-338 N199PLDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-167 N1GFFlowers George D · Panama City, FLBuilt 1982 · S/N LJ1031 N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361 N1UCBas Part Sales LLC · Greeley, COS/N LW-140 N200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293 N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568 N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40 N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410 N200RELw164 Inc Trustee · Wilmington, DEBuilt 1975 · S/N LW-164 N200RMMps Enterprises LLC · North Platte, NEBuilt 1973 · S/N LW-45 N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246 N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680 N200ZZAirtrex Aircraft Charlie Inc · Wichita, KSBuilt 1979 · S/N BC-64 N203PCEaton Brothers Transportation LLC · Riverside, MOS/N LW-258 N203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 1976 · S/N LW-203 N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658 N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115 N2050ATia Aeronautics Inc · Harlingen, TXBuilt 1978 · S/N LJ-813 N205MSJustice Air Inc · Farmingdale, NYBuilt 1981 · S/N LJ-948 N205STPate & Pate Air LLC · Andalusia, ALBuilt 1981 · S/N LJ-965 N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466 N207SBBlackbird Aero LLC · Boca Raton, FLS/N B-69 N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89 N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851 N208SRBardoo Urias L · Massapequa, NYBuilt 1974 · S/N B208 N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827 N20SA Paradise Repo LLC · Nokomis, FLBuilt 1978 · S/N LW-267 N20WPMoser Aircraft Service LLC · Huntington, INBuilt 1977 · S/N LJ-738 N210ECState Of Tennessee · Nashville, TNBuilt 1984 · S/N LJ-1070 N211CGAzul Air LLC · Dover, DES/N LW-101 N211VPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N B-2 N213PHPyro Shows Equipment LLC · La Follette, TNBuilt 1979 · S/N BB-486 N214PNavajo Nation · Window Rock, AZBuilt 1991 · S/N LJ-1293 N214SBSan Bernardino Co Sherriffs Dept · San Bernardino, CABuilt 1975 · S/N BC-02 N214SCAzul Air LLC · Dover, DEBuilt 1976 · S/N LW-96 N217CMKlas-Kcoe LLC · Las Vegas, NVBuilt 1980 · S/N BB-621 N217MLDodson Intl Parts Inc · Rantoul, KSS/N BB739 N2192LSiller Brothers Incorporated · Yuba City, CABuilt 1976 · S/N LW-192 N219WWTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1975 · S/N B-219 N21DELocke-Lane Aviation LLC · Statesville, NCBuilt 1976 · S/N BB-117 N21DZBravo Hotel LLC · Lewes, DEBuilt 1977 · S/N BC-32 N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839 N220TTShannair LLC · Saint Louis, MOS/N BB-462 N222KCU S Army - Owner · New Century, KSBuilt 1979 · S/N BC-68 N222LAGrb Logistics LLC · Grapevine, TXBuilt 1978 · S/N BB-409 N223LHLelah Holdings Limited Partnership · Reno, NVBuilt 1976 · S/N B-223

Back to AD 80-09-03 R1