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.

N901BABismarck Air Medical LLC · Bismarck, NDBuilt 1980 · S/N BB-674 N901FFFlightline Holdings II LLC · New Orleans, LABuilt 1980 · S/N BB-637 N901JEDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N LJ-1030 N901TMMatanane Roke C · Barrigada, GUBuilt 1977 · S/N LW-227 N901WLBas Part Sales LLC · Greeley, COBuilt 1968 · S/N LJ-410 N9029RArx Aviation LLC · Eustis, FLBuilt 1975 · S/N LW-132 N902MBB & M Aviation LLC · Bonneau, SCBuilt 1974 · S/N LW-105 N902VDDavis Aviation Inc · Brandon, MSS/N B-201 N904HBohanon Air LLC · Jonesboro, ARBuilt 1979 · S/N LW-239 N904PB34 Bravo LLC · Pine Bluff, ARBuilt 1981 · S/N LJ-962 N905NDDodson International Parts Inc · Rantoul, KSS/N BB-468 N905NYAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-6 N908KPetors John W · Addison, TXBuilt 1970 · S/N LJ-504 N90AWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N LJ-697 N90CTToccoa Group LLC · Odessa, FLBuilt 1974 · S/N LJ-645 N90DNNational Aerotech Aviation Delaware Inc · Wilmington, DEBuilt 1969 · S/N LJ-437 N90ELTrue Airspeed LLC · Pace, FLBuilt 1973 · S/N LJ-592 N90JNScg Leasing LLC · Owensboro, KYBuilt 1973 · S/N LW-74 N90KALj369 LLC · Opa Locka, FLBuilt 1968 · S/N LJ-369 N90LBMaza Flight LLC · Wilmington, DEBuilt 1973 · S/N LJ-573 N90MEMonument Aviation LLC · North Chesterfield, VABuilt 1975 · S/N LJ-661 N90MURwc Aircraft Sales LLC · Gillespie, ILBuilt 1976 · S/N LJ-679 N90NCDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N LJ342 N90PHTriple R Spraying LLC · Dumas, TXBuilt 1973 · S/N LW-60 N90TJTalcorp Ec Inc · Justin, TXS/N LW-228 N90WJDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-525 N90WLUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1969 · S/N LJ-461 N911CXCentral Virginia Aviation Inc · Petersburg, VAFirst renewal noticeBuilt 1979 · S/N LJ-830 N911FNApollo Aviation LLC · Las Vegas, NVBuilt 1976 · S/N LJ-688 N915CDN915cd LLC · Woodland, CABuilt 1977 · S/N LJ748 N918CACalifornia Highway Patrol · Sacramento, CABuilt 1978 · S/N BC-57 N918SAThiel Air Care Inc · Chowchilla, CABuilt 1980 · S/N LJ918 N918VSDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-200 N919REIvy Brothers Aviation LLC · Kilgore, TXS/N BB824 N91KABank Of Utah Trustee · Salt Lake City, UTS/N LJ-1232 N91MFCkw Aviation LLC · Dalhart, TXBuilt 1980 · S/N BB-657 N91RKAir Flight Inc · Fort Lauderdale, FLBuilt 1976 · S/N B-226 N923ASDjp Properties LLC · Selma, CABuilt 1979 · S/N BB-541 N923CRWc&R LLC · Austin, TXBuilt 1984 · S/N LJ-1074 N924ACDena'Ina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB483 N925ARRnjs Products LLC · Lewes, DEBuilt 1977 · S/N LJ-725 N92DVMile Hi Skydivers Inc · Longmont, COS/N LW-292 N93ABernhard Leasing LLC · Ashland, OHBuilt 1973 · S/N LW-63 N93GTDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N B-179 N93LPKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N LJ-901 N93SFArctic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-13 N93VDAbsl Construction · Hayward, CABuilt 1972 · S/N B-118 N93WTWes Tex Drilling Company · Abilene, TXBuilt 1979 · S/N BE-80 N944KCarmine Labriola Inc · Scarsdale, NYBuilt 1969 · S/N LJ-467 N944LSJmb Air LLC · Algona, IABuilt 1979 · S/N BB-604

Back to AD 80-09-03 R1