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.

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 N841KYPinaire Holdings LLC · Hendersonville, TNS/N BB-841 N844CN844c LLC · Fort Lauderdale, FLS/N LJ-866 N847BABeech Transportation Inc · Eden Prairie, MNBuilt 1981 · S/N BB847 N847DBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N BE-91 N84CANeojet N84ca LLC · Reno, NVBuilt 1976 · S/N BB-166 N84XPF B T Services LLC · Portland, ORBuilt 1979 · S/N BB481 N850BKRpm Consulting LLC · Middletown, DEBuilt 1981 · S/N BB-896 N851KADodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N LJ-851 N852JPDavis Aviation Inc DBA · Brandon, MSBuilt 1979 · S/N BB-516 N859GAIsr Platforms LLC · Mclean, VABuilt 1980 · S/N BT-12 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 N85UTFly Mwm LLC · Kemah, TXBuilt 1980 · S/N BB-678 N8611RGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-482 N861ZGGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-493 N862HTSublett Holdings LLC · Wilmington, DEBuilt 1981 · S/N BB-800 N867SLSafeco Leasing LLC · Port Alsworth, AKS/N BB-867 N86NBClairmont Holdings Vi LLC · St Thomas, VIS/N B166 N870SCElite Air LLC · Jonesboro, ARBuilt 1978 · S/N LJ-773 N875SPPacific Mission Aviation · Hagatna, GUBuilt 1975 · S/N BB-86 N876ATTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N BB-931 N876PAPax.Dei LLC · Hot Springs, ARBuilt 1977 · S/N LJ-757 N879TYKimmel Aviation LLC · Madison, MSBuilt 1978 · S/N BB-498 N87CHTld LLC · Pasco, WABuilt 1972 · S/N LW-20 N87NWAlbatross Air Inc · Beaver, WVBuilt 1978 · S/N BE-42 N888ETBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N BB-258 N888HJAviation Company Inc · Cheyenne, WYBuilt 1979 · S/N BB444 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 N88MTFlight Company LLC · Rome, GABuilt 1981 · S/N BB-830 N88WAWiseman Aviation Inc · Flagstaff, AZBuilt 1983 · S/N LJ-1057 N890NCDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N LJ-893 N896CMXrp Investments LLC · Clyde, MIBuilt 1980 · S/N BB-668 N899DCentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-386 N899SDRed Rock Aviation LLC · Dover, DEBuilt 1981 · S/N BB-776 N89MVLegacy Aviation Trust Holdings Corp Trustee · Doral, FLS/N BB-766 N8AMMraf LLC · Wilmington, DEBuilt 1977 · S/N BB-274 N8EFMcco Inc · Tuscumbia, ALBuilt 1980 · S/N BB-721 N8GUAugusta Aviation Inc · Hilton Head Island, SCBuilt 1985 · S/N LJ-1103 N8KBBiddulph Oldsmobile Inc · Phoenix, AZBuilt 1978 · S/N BB-446 N8NXExecutive Aviation Group Inc · Saint Petersburg, FLBuilt 1980 · S/N BB-774 N900ACTurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N LW282 N900DZCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1974 · S/N LJ-618 N900MTLincoln Ventures LLC · North Highlands, CABuilt 1983 · S/N LJ1048

Back to AD 80-09-03 R1