Registered aircraft · 1,179

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-22-01-R1-L') 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-22-01-R1-L') 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-22-01-R1-L')
    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-22-01-R1-L')
  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-22-01-R1-L')
  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-22-01-R1-L')
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.

N322NBlue Sky LLC · Anchorage, AKS/N 1507 N324CMClarke Environmental Mosquito Management · Roselle, ILBuilt 1977 · S/N 2303 N327AEAir Evac Ems Inc · O Fallon, MOBuilt 1990 · S/N 51365 N32AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45327 N32KYEnglish Air Service LLC · Santa Maria, CABuilt 1979 · S/N 2875 N331MHKt Auburndale LLC · Panama City Beach, FLBuilt 1982 · S/N 3564 N332MHXtreme Aviation LLC · Falkville, ALBuilt 1980 · S/N 2958 N333EROrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45203 N333FCGolden Ranch Aviation Inc · Raceland, LABuilt 1975 · S/N 1763 N333LWBohica Consulting Service Of Nevada Inc · Boulder City, NVBuilt 1980 · S/N 2932 N334AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51326 N334KCHawk Hollow Farm LLC · Brighton, MIBuilt 1994 · S/N 4303 N335DMSmith Steven Lee · Whitehall, MTBuilt 1981 · S/N 3330 N337AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45383 N3399Scotts Helicopter Service · Le Sueur, MNBuilt 1968 · S/N 305 N33PPUnited States Department Of Interior · Boise, IDBuilt 1983 · S/N 51051 N33QPAir Metro Helicopter Inc · New City, NYBuilt 1979 · S/N 2753 N33RSFlying H Limited LLC · Mesa, AZBuilt 1992 · S/N 51568 N343ALBtak LLC · New Baden, ILBuilt 1990 · S/N 51372 N345RRChemair Helicopters Inc · Jefferson, WIBuilt 1977 · S/N 2107 N346ERCibaoair Aviation Group Inc · Middletown, DEBuilt 1995 · S/N 4337 N34AETrinkle Aviation LLC · Kingsburg, CABuilt 1979 · S/N 45218 N34CTCorporate Auto Brokers Inc DBA · Cleveland, GABuilt 2001 · S/N 4545 N34EWPlane Fun Inc Tr Trustee · Snellville, GAS/N 2108 N351RLOas2 LLC · Orlando, FLBuilt 1991 · S/N 51431 N3521TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1979 · S/N 2703 N3523TMoreau Robert D · Granbury, TXBuilt 1979 · S/N 2637 N3528TR&B Helicopters Inc · Salinas, CABuilt 1981 · S/N 3516 N352MCCitrus County Mosquito Control District · Lecanto, FLBuilt 1973 · S/N 1131 N356LArizona Helicopter Services LLC · Prescott, AZS/N 51378 N357MCHillsborough County Board Of County Commissioners · Tampa, FLBuilt 1995 · S/N 4355 N358HPMoe Dubois Excavating Inc · Shelburne, VTS/N 662 N358RLTopside Aviation Inc · Brasstown, NCBuilt 1979 · S/N 2736 N35RPB & B Investments Inc · Yucaipa, CAS/N 1431 N361ALBillings Flying Service LLC · Billings, MTBuilt 1987 · S/N 51212 N362ALMarks Lloyd · Lafayette, LABuilt 1991 · S/N 51471 N365JJtjl Leasing LLC · Cortez, COBuilt 2007 · S/N 4632 N368CBAero Leasing LLC · Virden, ILBuilt 1975 · S/N 1655 N36MKHorizon Helicopters Inc · Newark, DEBuilt 1974 · S/N 1360 N36MQRotor LLC · Dover, DEBuilt 1993 · S/N 4262 N370DPDodson International Parts Inc · Rantoul, KSBuilt 1992 · S/N 51569 N376BTAppshle Air LLC · Long Beach, CABuilt 1979 · S/N 2767 N3777MRotor Co · New Braunfels, TXBuilt 1991 · S/N 51485 N377LFHelicopter Parts International Inc · Minden, NVBuilt 1989 · S/N 51281 N37AJL&R Investment Partners LLC · Wilmington, DES/N 1877 N382CAChem-Air LLC · Shreveport, LABuilt 1977 · S/N 2091 N382SPTag Aviation LLC · Casper, WYBuilt 1977 · S/N 2271 N383SHAspen Helicopters Inc · Oxnard, CABuilt 1983 · S/N 51073 N386PZFast Boy Equipment LLC · Houston, TXS/N 407 N38885Back Nine Aerial LLC · New Berlin, WIBuilt 1981 · S/N 45726

Back to AD 89-22-01 R1 L