AD 2002-25-07

Registered aircraft · 542

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-25-07')
    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-25-07')
  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.

N486AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52467N48AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45562N490AEAir Evac Ems Inc · O Fallon, MOFirst renewal noticeBuilt 2006 · S/N 52336N49MAAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1992 · S/N 52001N4CQHelicopters Inc · Cahokia, ILBuilt 1994 · S/N 52088N4KAAmbrose Group Inc · Bellevue, WABuilt 1992 · S/N 51578N5000BAir Flite Inc · Shawnee, OKS/N 51044N5000GTimberland Helicopters Inc · Ashland, ORBuilt 1978 · S/N 45163N50046Orlando Aircraft Sales LLC · Orlando, FLBuilt 1978 · S/N 45173N5007FPatriot Aviation Inc · Greenville, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 45186N5013GHmc Lift LLC · Wilmington, DEBuilt 1979 · S/N 45254N5017GHelimontana.Com LLC · Livingston, MTBuilt 1979 · S/N 45228N505RLOrgis Bj · Hallettsville, TXBuilt 1978 · S/N 45176N514RLSlikker Flying Service Inc · Buttonwillow, CABuilt 1991 · S/N 51514N516LERotor Republic LLC · Orlando, FLBuilt 1978 · S/N 45162N520RLPremier Rotors LLC · Saint Martinville, LABuilt 1993 · S/N 52052N523RLLarson Helicopters LLC · Perham, MNBuilt 2005 · S/N 52321N523TDTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 52388N52AEAir Evac Ems Inc · O Fallon, MOS/N 45758N52GHPleasant Gap Land Co Inc · State College, PABuilt 1989 · S/N 51276N52PLParatus Air DBA · Auburn, INS/N 45744N53702Helicopter Applicators Inc · Gettysburg, PABuilt 1983 · S/N 51249N538TDEl Destino LLC · Monticello, FLBuilt 1996 · S/N 52169N539AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52468N53AEAir Evac Ems Inc · O Fallon, MOS/N 45300N545SAShier Aviation Corp · San Diego, CABuilt 1983 · S/N 51063N547AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52471N54AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45157N54NYWisk Aero LLC · Mountain View, CABuilt 1983 · S/N 45770N54SPIndiana State Police · Indianapolis, INS/N 51062N552AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52478N553AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52474N558AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52470N559AEAir Evac Ems Inc · O'Fallon, MOBuilt 2015 · S/N 52472N55SLHelicopters Inc · Cahokia, ILBuilt 2007 · S/N 52347N560PK&D Aviation LLC · Kingston, OKBuilt 1982 · S/N 51013N563AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52475N566AFRickards Aviation Group LLC · Dagsboro, DEBuilt 1981 · S/N 45565N56757Jbi South Leasing LLC · Pembroke, NHBuilt 1994 · S/N 52072N567AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52477N569THelicopters Inc · Wilmington, DEBuilt 2004 · S/N 52290N570JHHarnden Aviation Group LLC · Harrisburg, PABuilt 1980 · S/N 45428N570KDK&D Aviation LLC · Kingston, OKBuilt 1994 · S/N 52079N570LEHhl LLC · Denver, COS/N 45570N570RLJasons Helicopter Services · New Prague, MNBuilt 1980 · S/N 45517N571CJRotorpro LLC · Sevierville, TNBuilt 1983 · S/N 45781N57441Jbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45438N5745YMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45531N57491Monarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45505N574AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52476
Back to AD 2002-25-07