OpenAirDocs.org
AD 78-24-06 R1

Registered aircraft · 155

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:78-24-06-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:78-24-06-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.

N461RARanger Aviation Leasing LLC · Wilmington, DES/N 45461N48AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45562N5000GTimberland 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 45176N516LERotor Republic LLC · Orlando, FLBuilt 1978 · S/N 45162N52AEAir Evac Ems Inc · O Fallon, MOS/N 45758N52PLParatus Air DBA · Auburn, INS/N 45744N53AEAir Evac Ems Inc · O Fallon, MOS/N 45300N54AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45157N54NYWisk Aero LLC · Mountain View, CABuilt 1983 · S/N 45770N566AFRickards Aviation Group LLC · Dagsboro, DEBuilt 1981 · S/N 45565N570JHHarnden Aviation Group LLC · Harrisburg, PABuilt 1980 · S/N 45428N570LEHhl 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 45505N5751MTrinkle Aviation LLC · Kingburg, CABuilt 1980 · S/N 45522N595AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45244N59AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45291N59CHAir Center Helicopters Inc · Burleson, TXS/N 45284N601GMNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1981 · S/N 45638N619Air Flite Inc · Shawnee, OKBuilt 1980 · S/N 45393N63AEAir Evac Ems Inc · O Fallon, MOS/N 45499N64FCZma LLC · North Little Rock, ARBuilt 1981 · S/N 45539N660HAHelicopter Applicators Inc · Gettysburg, PABuilt 1979 · S/N 45219N6651HR & R Conner Aviation LLC · Conner, MTBuilt 1979 · S/N 45211N66RRRiggs Rock Alan · Lake Mary, FLBuilt 1979 · S/N 45278N68AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45647N720BGentem Inc Trustee · Wilmington, DEBuilt 1980 · S/N 45452N749FFHunt-Lo Farms LLC · Chesterland, OHBuilt 1983 · S/N 45773N76DCAdvanced Trucking LLC · Kalispell, MTBuilt 1980 · S/N 45471N777EMAlaskan Wings LLC · Anchorage, AKBuilt 1983 · S/N 45767N7978KMowata Farms LLC · Mamou, LABuilt 1982 · S/N 45492N79AEAvid Aviation Group Inc · Jupiter, FLBuilt 1980 · S/N 45436N79LRHeger Scott · Scappoose, ORBuilt 1979 · S/N 45200N79TVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 45718N7DQMinnesota Helicopters Inc · Blaine, MNBuilt 1981 · S/N 45685N801CLAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1979 · S/N 45354N828WPBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 45294N83AEAir Evac Ems Inc · O Fallon, MOS/N 45272N853SSTippmann Choppers LLC · Fort Wayne, INBuilt 1980 · S/N 45584N85AWScotts Helicopter Service · Le Sueur, MNS/N 45261N89AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45433N902EHNorth Wind Aviation LLC · Chelan, WAS/N 45769
Back to AD 78-24-06 R1