Registered aircraft · 674

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:89-07-07-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:89-07-07-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:89-07-07-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:89-07-07-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:89-07-07-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:89-07-07-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.

N100BYFirst Flight Aviation LLC · Boerne, TXBuilt 1984 · S/N 1565 S.A.N100MUWakaya Services Inc · Dover, DEBuilt 1980 · S/N 793SA N100TWTexas La Flyers LLC · Monroe, LABuilt 1978 · S/N BE-51 N10192Frontier Agricultural Service Inc · Calexico, CABuilt 1989 · S/N 401-0731 N101MCMarc Inc · Bolton, MSBuilt 1973 · S/N T234 N101WAP M Leasing Inc · Perris, CABuilt 1969 · S/N SH1859 N103SLAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N 11735 N1050HBush Monster LLC · Caldwell, IDBuilt 2024 · S/N 001 N107BHBighorn Airways Inc · Sheridan, WYBuilt 1979 · S/N 165 N108EBAndrie Inc · Muskegon, MIBuilt 1980 · S/N BE-108 N109BHBighorn Airways Inc · Sheridan, WYBuilt 1981 · S/N 192 N112BHBighorn Airways Inc · Sheridan, WYS/N 292 N112CZDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 1981 · S/N 441-0233 N114HKGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2008 · S/N FC114 N114LHAirborne Support Group LLC · Marion, MTBuilt 1974 · S/N SH-1926 N1158Alaskan Air Charter LLC · Anchorage, AKS/N SH1951 N1164FRegistration Pending · Dickerson, MDRegistration pendingS/N 1562 S.A.N116TLTordrillo Mountain Aviation LLC · New York, NYBuilt 1956 · S/N 174 N117BHBighorn Airways Inc · Sheridan, WYBuilt 1980 · S/N 171 N117CCEv Advisors LLC · Scottsdale, AZBuilt 1979 · S/N T-325 N11SJSouthland Metroplex Aviation LLC · Colleyville, TXBuilt 1973 · S/N 285 N120TMInterstate Automotive Services Inc · Franklin, TNBuilt 1981 · S/N T-405 N1212CDodson International Parts Inc · Rantoul, KSBuilt 1985 · S/N 441-0346 N121JWGlobal Jet LLC · Missoula, MTBuilt 1975 · S/N 11299 N122CKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 374SA N122MAPanda Aviation Inc · Washougal, WAS/N 207 N124PAJ31 Partners LLC · Nashville, TNBuilt 1984 · S/N 643 N124PCSaxton Leasing Inc · Plymouth, MIS/N 438SA N1255TSierra Aeronautics LLC · Franklin, KYBuilt 1954 · S/N 55607 N125MMFox Tango Tango Inc · Houston, TXBuilt 1979 · S/N 11605 N128EZN128ez LLC · Anchorage, AKBuilt 1979 · S/N 441-0128 N12MFMontana Aircraft Trust Inc Trustee · Bozeman, MTS/N T-417 N12VAAirborne Research LLC · Fort Pierce, FLS/N 96062 N1331CRyan Air Inc · Anchorage, AKBuilt 1982 · S/N 265 N13YSAir 1st Aviation Companies Inc · Aiken, SCBuilt 1976 · S/N 694 N142JBAlaska Remote Outfitters LLC · Kenai, AKBuilt 1956 · S/N 74 N143JACosco & Associates Inc · Crestview, FLBuilt 1974 · S/N 324 N144PLCatskill Transportation LLC · Kingston, NYBuilt 1984 · S/N 42-5527014 N145FSSolitaire LLC · Appleton, WIS/N 437 S.A N14FJLand Safely LLC · Tinton Falls, NJBuilt 1980 · S/N 441-0118 N14NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1980 · S/N 4410171 N14TA35th Terrace LLC · Wellington, FLBuilt 1980 · S/N 441-0168 N150BAKenai River Xpress LLC · Soldotna, AKBuilt 1953 · S/N 15 N152AFUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N AC520 N158MCBemidji Aviation Services Inc · Bemidji, MNBuilt 1988 · S/N AC-726B N159MCGas/Wilson Inc · Traverse City, MIS/N AC-728B N15DBN15db LLC · Bend, ORBuilt 1981 · S/N 441-0278 N15TRNorthwest Aviation LLC · Fargo, NDBuilt 1981 · S/N 446 S.A.N162ALNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11231 N165MARegistered aircraftBuilt 1975 · S/N 326

Back to AD 89-07-07 R1