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.

N167RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 11437 N169CAArizona State University · Hilo, HIBuilt 1986 · S/N 8088 N169MFCommodore Aviation LLC · Palm Beach, FLBuilt 1981 · S/N 441-0221 N16NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0045 N170PCAircraft Propulsion Leasing LLC · Holland, OHBuilt 1986 · S/N 717 N171ATAloft Aviation Services LLC · Spartanburg, SCBuilt 1966 · S/N 1616-49 N175CAAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1979 · S/N 736SA N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3 N175SWDenaina Air Taxi LLC · Anchorage, AKBuilt 1985 · S/N AC 621-B N17758N17758 LLC · Salem, ORBuilt 1996 · S/N V55-396T N178SBCrawford Setrige · Santa Barbara, CAS/N 435 S.A.N17HGMu2 LLC · Lewes, DEBuilt 1981 · S/N 1510 S.A.N17VVPro Field Services Inc · Hallettsville, TXBuilt 1985 · S/N TT536 N1836CCascade Airways LLC · Jefferson, ORBuilt 1978 · S/N 36C N183AKRegistered aircraftBuilt 1981 · S/N TT471 N184SWCbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-647 N1880APlaneco LLC · Lincoln, NEBuilt 1978 · S/N 441-0080 N188HKGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2010 · S/N FC188 N190TCGeneral Atomics - Aeronautical Systems Inc · Poway, CAS/N YBC01 N192WWWin Win Aviation Inc · Wake Forest, NCBuilt 1977 · S/N SH1956 N193AABig Mountain Aviation Inc · Whitefish, MTBuilt 1979 · S/N 741SA N195WWWin Win Aviation Inc · Wake Forest, NCBuilt 1975 · S/N SH1939 N196MAStef Air LLC · Muscle Shoals, ALBuilt 1979 · S/N 764 S.A.N1MNDukes Garage LLC · Boulder, COBuilt 1981 · S/N TT-486A N200GCameron Global Strategies LLC · Springboro, OHBuilt 1981 · S/N 452 S.A.N200MHVouk Aviation LLC · Blackfoot, IDBuilt 1969 · S/N T26-148 N200SNAdvantage Jet Holdings LLC · Chino Hills, CABuilt 1980 · S/N T-354 N201BRSky Bus Inc · North Miami Beach, FLBuilt 1968 · S/N 166 N202WSCorsair Turbines LLC · Georgetown, TXBuilt 1975 · S/N AT037 N2042VAerial Crop Care Co · Hebron, NDBuilt 1998 · S/N G10-146 N20523Franklin Dirk W · Beaumont, TXBuilt 1998 · S/N G10-147 N2074JMauck Flying Service LLC · Hoxie, KSBuilt 1998 · S/N G1-109 N20BMKemore Crew Leasing Inc Trustee · Bellingham, WAS/N 1698-75 N20WEEvans Phyllis H Trustee · Riverside, CABuilt 1980 · S/N 441-0160 N2103BQuad Rabbit Inc · Wilmington, DEBuilt 1998 · S/N G10-148 N211RHMcneely Charter Service Inc · West Memphis, ARBuilt 1987 · S/N AC421B N212ADBrykin Leasing Corp · Celina, TXBuilt 1984 · S/N 273 N2136TWalvoord Spraying Service LLC · Hickman, NEBuilt 1998 · S/N G6-148 N2146SMoses Lake Warden Air Services Inc · Moses Lake, WABuilt 1998 · S/N G10-149 N216CDLandry Camile J · Baton Rouge, LABuilt 1974 · S/N 323 N217BHMorning Aero LLC · Colorado Springs, COBuilt 1984 · S/N 318 N218MSSasha Air LLC · Hingham, MABuilt 1981 · S/N 95041 N21GPKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC754B N2200QCarroll Flying Service Inc · Lake Providence, LABuilt 1998 · S/N G10-155 N220JSMt Mgt LLC · Missoula, MTBuilt 1981 · S/N 1545 S.A.N222GKTri-County Sprayers Inc · Hamlin, TXBuilt 1997 · S/N G6-145 N222MEClearwater Airco LLC · Anchorage, AKS/N 11338 N2237DFountain Flying Service LLC · Moscow, IDBuilt 1996 · S/N G1-104 N2239CJk Skyfarm LLC · Adairville, KYBuilt 1996 · S/N G10-128 N2245SFernandez Rosario Yailin · Imperial, CAS/N G1-106

Back to AD 89-07-07 R1