Registered aircraft · 99

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:97-25-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-25-09') 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:97-25-09')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-25-09')
  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:97-25-09')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-25-09')
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.

N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062 N105HHHaddock Flying Service Inc · Salters, SCS/N 1307 N10JSSiegel Jerry S · Los Angeles, CAS/N 008 N1201WMagnum Aviation LLC · Goff, KSBuilt 1966 · S/N 7819 N123HPSouthwest Heliservices LLC · Mesa, AZBuilt 1980 · S/N 45394 N123NMAglk LLC · Lewes, DES/N 6702 N12BFHutter Charles G · Carson City, NVBuilt 1974 · S/N 61P-0162-003 N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069 N142CCMachinery Service Co Inc · Wiscasset, MEBuilt 1997 · S/N 5025 N146ETFour Creeks Aviation Inc · Visalia, CABuilt 1976 · S/N HA3046 N14807Hammock Flying Service Inc · Smithville, ARBuilt 1972 · S/N 25078 N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339 N1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044 N16KKS & S Aviation Services Inc · Pacoima, CAS/N 49100 N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170 N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075 N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346 N2068WChewale Inc · Beaverton, ORBuilt 1976 · S/N N.C.013 N20SPNew York State Police · Albany, NYBuilt 2000 · S/N 49070 N210SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N P21000621 N21772N21772 LLC · Wellington, FLBuilt 1967 · S/N 970134 N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593 N2240WYarak Aviation LLC · Big Timber, MTBuilt 1962 · S/N 6752 N2251WJohnson Aerial Spraying LLC · Brayton, IAS/N 7965 N2266ADt Pralle Enterprise Inc · Hampton, IABuilt 1966 · S/N 3557 N255MKPremier Aircraft Services LLC · Bakersfield, CABuilt 1996 · S/N 49007 N25LBScotts Helicopter Services Inc · Le Sueur, MNBuilt 1972 · S/N 25102 N2618WEnglish Air Service LLC · Georgetown, TXBuilt 1966 · S/N 6580 N2672Reynolds Aviation LLC · Wills Point, TXBuilt 1992 · S/N E-2672 N27HXHelicopter Express LLC · Chamblee, GABuilt 1996 · S/N 53012 N28LZLindemann Thomas · Gustine, CABuilt 1981 · S/N U20606531 N3094GScotts Helicopter Services Inc · Le Sueur, MNBuilt 1965 · S/N 3361 N3324FSummit Sales & Leasing Inc · Salem, VABuilt 1964 · S/N 1735 N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253 N34SFlying Tigers LLC · Jefferson City, MOBuilt 2002 · S/N 49092 N40290Haddock Flying Service Inc · Salters, SCBuilt 1980 · S/N HA3081 N4032YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 5180 N4068GGulf Coast Helicopters Inc · Pearland, TXBuilt 1968 · S/N 229 N407CCCounty Of Contra Costa · Martinez, CABuilt 1997 · S/N 53090 N407CHClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53011 N407FCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1996 · S/N 53050 N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036 N40DPLondonaire LLC · Wichita Falls, TXBuilt 1997 · S/N 49035 N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493 N410SCAlfheim II LLC · Menomonee Falls, WIBuilt 1998 · S/N 5026 N427SPState Of New York · Albany, NYBuilt 2001 · S/N 49083 N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045 N430CFSan Juan Aviation LLC · Wilmington, DEBuilt 2006 · S/N 49118 N430DWGear Aviation LLC · Missoula, MTBuilt 2001 · S/N 49079

Back to AD 97-25-09