OpenAirDocs.org
AD 2002-06-08

Registered aircraft · 131

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

N101ALRegistered aircraftBuilt 1980 · S/N U20605684N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062N105HHHaddock Flying Service Inc · Salters, SCS/N 1307N105SDHeli Flite Inc · Corona, CABuilt 1998 · S/N 2052N106AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45566N1085TAspen Helicopters Inc · Oxnard, CABuilt 1980 · S/N 45376N10JSSiegel Jerry S · Los Angeles, CAS/N 008N110LTLt Aviation LLC · Louisa, KYBuilt 1981 · S/N 45676N1171Agricultural Air Services LLC · Jupiter, FLBuilt 1979 · S/N 45234N1201WMagnum Aviation LLC · Goff, KSBuilt 1966 · S/N 7819N123NMAglk LLC · Lewes, DES/N 6702N12AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45649N12BFHutter Charles G · Carson City, NVBuilt 1974 · S/N 61P-0162-003N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069N134AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45593N138AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45782N142CCMachinery Service Co Inc · Wiscasset, MEBuilt 1997 · S/N 5025N144TVAir Flite Inc · Shawnee, OKBuilt 1982 · S/N 45602N146ETFour Creeks Aviation Inc · Visalia, CABuilt 1976 · S/N HA3046N14807Hammock Flying Service Inc · Smithville, ARBuilt 1972 · S/N 25078N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339N1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075N176AEAir Evac Ems Inc · Ofallon, MOBuilt 1979 · S/N 45224N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346N2009CMeridian Helicopters LLC · Broussard, LABuilt 1982 · S/N 45678N2068WChewale Inc · Beaverton, ORBuilt 1976 · S/N N.C.013N206SLAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1979 · S/N 45245N20SPNew York State Police · Albany, NYBuilt 2000 · S/N 49070N210SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N P21000621N2122T22t Aero LLC · Hermosa Beach, CAS/N 45587N21772N21772 LLC · Wellington, FLBuilt 1967 · S/N 970134N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593N2240WYarak Aviation LLC · Big Timber, MTBuilt 1962 · S/N 6752N2251WJohnson Aerial Spraying LLC · Brayton, IAS/N 7965N2266ADt Pralle Enterprise Inc · Hampton, IABuilt 1966 · S/N 3557N233BBTop Gun Precision Ag LLC · Skidmore, TXBuilt 1980 · S/N 45489N249THTimberland Helicopters Inc · Ashland, ORBuilt 1980 · S/N 45459N25LBScotts Helicopter Services Inc · Le Sueur, MNBuilt 1972 · S/N 25102N2611Jbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45417N2618WEnglish Air Service LLC · Georgetown, TXBuilt 1966 · S/N 6580N2672Reynolds Aviation LLC · Wills Point, TXBuilt 1992 · S/N E-2672N274AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45762N27HXHelicopter Express LLC · Chamblee, GABuilt 1996 · S/N 53012N28LZLindemann Thomas · Gustine, CABuilt 1981 · S/N U20606531N292AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45780N3094GScotts Helicopter Services Inc · Le Sueur, MNBuilt 1965 · S/N 3361N315AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45482N315MHCane Helicopter Services LLC · Franklin, LABuilt 1981 · S/N 45692
Back to AD 2002-06-08