Registered aircraft · 728

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:81-23-01-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:81-23-01-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:81-23-01-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:81-23-01-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:81-23-01-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:81-23-01-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.

N86NBClairmont Holdings Vi LLC · St Thomas, VIS/N B166 N870SCElite Air LLC · Jonesboro, ARBuilt 1978 · S/N LJ-773 N876PAPax.Dei LLC · Hot Springs, ARBuilt 1977 · S/N LJ-757 N87CHTld LLC · Pasco, WABuilt 1972 · S/N LW-20 N87EDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-05 N87NWAlbatross Air Inc · Beaver, WVBuilt 1978 · S/N BE-42 N87QDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-60 N87VDynamic Avlease Inc · Bridgewater, VAS/N LM-130 N888EKExcalibur Knight One LLC · Miami, FLBuilt 1967 · S/N LC-263 N888JTNyerges James · Midland, TXBuilt 1966 · S/N LP-21 N888ZTRev Aircraft LLC · Wilmington, DEBuilt 1978 · S/N LW315 N88FARegistration Pending · Helena, MTRegistration pendingBuilt 1979 · S/N BE-74 N88GLWichita State University · Wichita, KSBuilt 1981 · S/N LJ-945 N88HMFinch Air LLC · Midland, TXBuilt 1970 · S/N LJ-502 N88WAWiseman Aviation Inc · Flagstaff, AZBuilt 1983 · S/N LJ-1057 N890NCDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N LJ-893 N899CAAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-104 N899CZN899cz LLC · Milwaukee, WIS/N U-96 N899DCentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-386 N89FDynamic Avlease Inc · Bridgewater, VABuilt 1969 · S/N LM-124 N8GUAugusta Aviation Inc · Hilton Head Island, SCBuilt 1985 · S/N LJ-1103 N900ACTurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N LW282 N900BPColumbus State Community College · Columbus, OHBuilt 1965 · S/N LJ-61 N900DZCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1974 · S/N LJ-618 N900MTLincoln Ventures LLC · North Highlands, CABuilt 1983 · S/N LJ1048 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 N903MDMaryland Department Of Agriculture · Annapolis, MDBuilt 1968 · S/N LM-98 N904HBohanon Air LLC · Jonesboro, ARBuilt 1979 · S/N LW-239 N904PB34 Bravo LLC · Pine Bluff, ARBuilt 1981 · S/N LJ-962 N905NYAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-6 N906HFCavanaugh Air LLC · Addison, TXBuilt 1971 · S/N LM-140 N906MRMarc Aircraft Holding LLC · Soldotna, AKS/N LM-136 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 N90DDynamic Avlease Inc · Bridgewater, VABuilt 1970 · S/N LU-10 N90DNNational Aerotech Aviation Delaware Inc · Wilmington, DEBuilt 1969 · S/N LJ-437 N90ELTrue Airspeed LLC · Pace, FLBuilt 1973 · S/N LJ-592 N90FAFox Valley Technical College · Appleton, WIBuilt 1966 · S/N LJ-133 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

Back to AD 81-23-01 R1