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.

N77PFAerospace Asset Holdings LLC · Wilmington, DEBuilt 1970 · S/N B-70 N77WFKt Aviation LLC · Las Cruces, NMBuilt 1972 · S/N LW-4 N77WMWhiskey Mike Aero LLC · Wilmington, DEBuilt 1986 · S/N LJ-1133 N7817LNyerges James · Midland, TXBuilt 1967 · S/N LD-340 N781AKAlsworth Glen Sr · Port Alsworth, AKS/N B-53 N7862RUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-85 N787TTMjw Aviation LLC · Beaumont, TXS/N LJ-787 N78DDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-78 N78DARegistered aircraftBuilt 1976 · S/N BE-11 N790AWilliam C New Aviation Services LLC · Morgan City, LABuilt 1982 · S/N LJ-1016 N7931DJet Air Inc · Galesburg, ILBuilt 1982 · S/N LJ-1049 N797CFAmerican Aviation Inc · Brooksville, FLBuilt 1978 · S/N LJ-797 N799CZN799cz LLC · Milwaukee, WIBuilt 1969 · S/N U-68 N799DDRenfro Michael W · Bethel, AKBuilt 1971 · S/N B-102 N799GKCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-799 N79WDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-77 N7PCMoorhead Equipment LLC · Belton, SCBuilt 1966 · S/N LC-246 N800EQMccauley Kerry D · Menomonie, WIBuilt 1960 · S/N LF-24 N802BAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-29 N808SWFmgi Inc · Woodstock, GABuilt 1978 · S/N LJ801 N809DMAir Reldan Inc · Slidell, LABuilt 1980 · S/N LW-334 N80BTCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N LW-148 N80RDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-21 N80RRBemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-296 N80YDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-79 N8108REdge Logistics Inc · Southlake, TXBuilt 1969 · S/N LC-329 N810ADGulf States Air Inc · Bossier City, LAS/N LD-328 N811KCTwa International Inc · Cheyenne, WYBuilt 1979 · S/N LJ-869 N812ACInternational Air Services Inc Trustee · Carson City, NVS/N LJ-123 N813BLSarma Aviation LLC · Fort Wayne, INBuilt 1978 · S/N BE-55 N813JBDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N LJ-899 N81HPFly Buys Too LLC · Wilmington, DEBuilt 1973 · S/N LW-72 N820RDImhof Air 2 LLC · Ferndale, WABuilt 1973 · S/N LW-82 N821CBEz Transportation Inc · Rosharon, TXBuilt 1977 · S/N BE-35 N821VVElite Team Offices Inc · Clovis, CABuilt 1977 · S/N LJ-714 N825SDGreat Valley Management Inc · New Castle, DEBuilt 1996 · S/N LJ-1449 N827KBArkansas Air Partners LLC · Jonesboro, ARBuilt 1978 · S/N LW-287 N82XPJones Harry R Jr · Houston, TXBuilt 1982 · S/N LJ-1012 N83FEG&C Aviation LLC · Wilmington, DEBuilt 1977 · S/N LW-219 N83TCDel Mar College · Corpus Christi, TXBuilt 1969 · S/N LJ-483 N83WEMiner'S Inc · Hermantown, MNBuilt 1978 · S/N LW-289 N840STransnational Aviation LLC · Arlington, TXBuilt 1962 · S/N LF-38 N844CN844c LLC · Fort Lauderdale, FLS/N LJ-866 N844NBemidji Aviation Services Inc · Bemidji, MNS/N LF-42 N847DBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N BE-91 N84GDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-33 N851KADodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N LJ-851 N85DRWashington Air LLC · Richland, WABuilt 1978 · S/N LJ-767 N85GWMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1976 · S/N LJ-712 N85TBCentral Virginia Aviation Inc · Petersburg, VABuilt 1979 · S/N LJ-833

Back to AD 81-23-01 R1