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.

N431BGBismarck Air Medical LLC · Bismarck, NDBuilt 1980 · S/N LJ-933 N431RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B-71 N431ZTZimin Transportation LLC · South Naknek, AKBuilt 1976 · S/N BC-18 N438CRKilo Alpha 438 LLC · Edgewater, FLBuilt 1978 · S/N BB438 N438SErie Aviation LLC · Salem, ORBuilt 1981 · S/N BB-886 N439WAA W Peterson Inc · Warren, MNBuilt 1977 · S/N LW-216 N43ADynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BC-73 N43MBSky West Aviation Inc Trustee · Albuquerque, NMS/N LJ-463 N43PCOlsen Air LLC · Hendricks, MNBuilt 1977 · S/N LW-253 N43WAWhatever Aviation LLC · Olympia, WABuilt 1970 · S/N LJ-501 N4415LIdaho State University · Pocatello, IDS/N BE67 N442KAMoore Horizons LLC · Murrells Inlet, SCBuilt 1978 · S/N BB442 N443CLSkiing Aircraft Co LLC · Bloomfield Hills, MIBuilt 1979 · S/N LW-318 N4447WJvs86 LLC · Scottsdale, AZBuilt 1974 · S/N LJ-627 N444ADApex Aviation Holding LLC · Kalispell, MTBuilt 1980 · S/N BB-733 N444LPierwest Aviation LLC · Tulsa, OKBuilt 1980 · S/N LW-344 N444RKOrmond Beach Jet LLC · Ormond Beach, FLBuilt 1983 · S/N BE-137 N4490MIndian Ink Leasing Inc · Amarillo, TXBuilt 1979 · S/N BE-64 N44HPAime High LLC · Lake City, FLBuilt 1976 · S/N LJ-702 N44MRSummit Helicopters Inc · Salem, VAS/N BL-27 N44UDynamic Avlease Inc · Bridgewater, VAS/N BT-14 N44USEagle Creek Aviation Services Inc · Indianapolis, INBuilt 1975 · S/N BB-56 N456PFCivic Aviation LLC · Miami, FLBuilt 1978 · S/N BB-413 N459MARani9650 LLC · Lathrop, CABuilt 1975 · S/N BB-36 N45SADavis Aviation Inc · Brandon, MSBuilt 1980 · S/N LJ-903 N463RSRts Aviation LLC · Atlanta, GABuilt 1987 · S/N LJ-1143 N465BKDodson International Parts Inc · Rantoul, KSS/N BB-382 N465TASouthwest Aviation Specialties LLC · Tulsa, OKS/N LJ630 N469BUnited States Construction Corporation · Pompano Beach, FLBuilt 1978 · S/N LJ-803 N46BRCds Aviation Consulting LLC · Dover, DEBuilt 1981 · S/N BB-852 N46CVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N LJ-568 N46LDynamic Avlease Inc · Bridgewater, VABuilt 1978 · S/N BC-56 N46RPJst Management LLC · Zephyrhills, FLBuilt 1976 · S/N LW-193 N46SBDavis Aviation Inc DBA · Brandon, MSS/N LW-312 N472EAWashington State Community College · Spokane, WAS/N LW-250 N4776MPassion Aviation LLC · Bells, TXBuilt 1978 · S/N LJ-776 N477JMBehrens Aircraft Leasing LLC · Waukesha, WIBuilt 1979 · S/N BB-538 N477MAircraft Unlimited Inc · Pierre, SDBuilt 1987 · S/N LJ-1154 N478CRAlg Aircraft LLC · Delano, CABuilt 1997 · S/N LJ-1474 N479AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1970 · S/N B-96 N481ZGalazy Lift II LLC · New York, NYBuilt 1973 · S/N LW-52 N484MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 1978 · S/N LJ-807 N485KBravo Hotel LLC · Lewes, DEBuilt 1979 · S/N BB-485 N487JHCtgx Holdings LLC · Alpine, WYBuilt 1978 · S/N BE-43 N48AZStover Aviation LLC · Dallas, GABuilt 1979 · S/N LJ-859 N48CVAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1976 · S/N BB-189 N48WPlatina Investment Corporation · Oklahoma City, OKBuilt 1977 · S/N LW-254 N490DMFlying Colors Air Parts Inc · Leesburg, FLS/N LJ468 N4947MKca Of Montana LLC · Helena, MTBuilt 1978 · S/N LJ-780 N495NMCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-781

Back to AD 80-09-03 R1