Registered aircraft · 286

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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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:98-20-38-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.

N381RUc Aviation Holdings LLC · Union City, TNBuilt 1978 · S/N BB-385 N382ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-36 N383ATAirtrex Aircraft Juliet Inc · Wichita, KSS/N FE-10 N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615 N384ATAirtrex Aircraft Kilo Inc · Wichita, KSS/N FE-23 N385ATAirtrex Aircraft Lima Inc · Wichita, KSBuilt 1989 · S/N FE-22 N393JWGeneration Jets LLC · Denison, TXBuilt 1977 · S/N BB-292 N3HBSunset Aviation LLC · Port Angeles, WABuilt 1979 · S/N BB-453 N400SLTurbo Air Charter LLC · Boise, IDBuilt 1980 · S/N BB-697 N4047CInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N BB202 N404DPValie Air LLC · Statesboro, GABuilt 1981 · S/N BB-819 N409RATurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N BB-429 N40RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BC-7 N40SBSan Bernadino County Sheriffs Office · San Bernardino, CABuilt 1976 · S/N BD-09 N40YDynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BP-30 N411MHObair 26 LLC · Memphis, TNBuilt 1979 · S/N BB-566 N416DFUsda Forest Service · Mcclellan, CABuilt 1985 · S/N BL-124 N419MNSouthern Justice Aviation LLC · Houston, TXBuilt 1980 · S/N BB-785 N420TAElectronic Caregiver Inc · Las Cruces, NMBuilt 1978 · S/N BB-420 N42JCrania Holdings LLC · Peoria, ILBuilt 1977 · S/N BC-29 N42ZDynamic Avlease Inc · Bridgewater, VABuilt 1976 · S/N BC28 N430MCDenault John B III · Fullerton, CABuilt 1981 · S/N BB-904 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 N43ADynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BC-73 N442KAMoore Horizons LLC · Murrells Inlet, SCBuilt 1978 · S/N BB442 N444ADApex Aviation Holding LLC · Kalispell, MTBuilt 1980 · S/N BB-733 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 N459DFState Of California · Mcclellan, CAS/N BP-027 N459MARani9650 LLC · Lathrop, CABuilt 1975 · S/N BB-36 N461DFState Of California · Mcclellan, CABuilt 1981 · S/N BP-029 N463DFState Of California - Cal Fire · Mcclellan, CABuilt 1981 · S/N BP-024 N465BKDodson International Parts Inc · Rantoul, KSS/N BB-382 N46BRCds Aviation Consulting LLC · Dover, DEBuilt 1981 · S/N BB-852 N46LDynamic Avlease Inc · Bridgewater, VABuilt 1978 · S/N BC-56 N477JMBehrens Aircraft Leasing LLC · Waukesha, WIBuilt 1979 · S/N BB-538 N485KBravo Hotel LLC · Lewes, DEBuilt 1979 · S/N BB-485 N48CVAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1976 · S/N BB-189 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 N501EBPrecision Holdings LLC · Kimberly, IDBuilt 1978 · S/N BB-422 N501HKBam Aviation LLC · Baton Rouge, LABuilt 1979 · S/N BB-565 N502APJbjp Capital Holdings LLC · Newark, DEBuilt 1984 · S/N BB-1187 N503JMDls Aviation LLC · Gilmer, TXBuilt 1980 · S/N BB-712

Back to AD 98-20-38 R1