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.

N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13FPSafeco Leasing LLC · Port Alsworth, AKS/N B-44 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585 N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35 N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214 N14VDouble D International LLC · Miami, FLS/N LJ-411 N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50 N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678 N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371 N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260 N152WWNardi Greg · Missoula, MTS/N LJ-654 N155LSRainair Avionics Services LLC · Albertville, ALS/N LW-286 N1560Davis Aviation Inc · Brandon, MSS/N BC-09 N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156 N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157 N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457 N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32 N162MCBank Of Utah Trustee · Salt Lake City, UTS/N B137 N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300 N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054 N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28 N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006 N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3 N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183 N176JRKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1974 · S/N LW-115 N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029 N176TWSierra American Corporation · Wilmington, DEBuilt 1974 · S/N LW-76 N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191 N177MKTrans Equipment Svcs Inc · Greenville, SCBuilt 1975 · S/N LW-149 N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236 N17NMCentral Virginia Aviation Inc · Petersburg, VABuilt 1977 · S/N LW-237 N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670 N1801BSjd Flight LLC · Houston, TXBuilt 1974 · S/N LJ-634 N183SADriscoll David A · Savannah, TNBuilt 1973 · S/N LJ571 N187ALAlm Holdings Delaware 2 LLC · Wilmington, DES/N LJ842 N187MRJcs Air LLC · Auburn, ALS/N BB-873 N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111 N188LLTriple Aviation LLC · San Leon, TXBuilt 1981 · S/N BE-119 N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32 N189APRegistered aircraftBuilt 1975 · S/N BB-59 N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360 N18MYWorld Aircraft Leasing Inc · Wilmington, DES/N LJ562 N190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N LW-345 N190EFTriple E Farms LLC · Pasco, WABuilt 1985 · S/N LJ-1122

Back to AD 80-09-03 R1