OpenAirDocs.org
AD 78-25-08 R3

Registered aircraft · 561

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

N441WTHaven Air LLC · Winter Garden, FLBuilt 1983 · S/N 441-0313N444WDFlyto LLC · Indianapolis, INBuilt 1988 · S/N 96006N445DFUsda Forest Service Fepp · Mcclellan, CABuilt 2004 · S/N 152345N448CASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 425527034N4490MIndian Ink Leasing Inc · Amarillo, TXBuilt 1979 · S/N BE-64N449BKMu2b40 LLC · Rancho Santa Fe, CABuilt 1981 · S/N 449 S.A.N44AFTrinity Group · Watford City, NDBuilt 1981 · S/N 790SAN44MXRiver City Aviation Inc · Fairdealing, MOBuilt 1981 · S/N 1526 S.A.N450DFUsda Forest Service Fepp · Mcclellan, CABuilt 2005 · S/N 152341N456GTConquest 294 LLC · Wilmington, DEBuilt 1982 · S/N 441-0294N459SASolitaire Leasing LLC · Evanston, ILS/N 459 S.A.N461MAGood Aviation LLC · Oshkosh, WIBuilt 1974 · S/N 301N462MARegistered aircraftBuilt 1974 · S/N 302N466DCAerotel Inc · Spring Hill, FLBuilt 1981 · S/N 1528SAN466SMMiddleton Lee Sam · Lubbock, TXBuilt 1982 · S/N 441-0300N467MAAlc Aviation LLC · Cheyenne, WYS/N 1567SAN46AKExpress Aviation Management LLC · Dover, DEBuilt 1979 · S/N 754S.A.N46HLGsp Air LLC · Sparta, NJBuilt 1985 · S/N 42-5527017N46LHSkyventure Arizona LLC · Reno, NVBuilt 1974 · S/N SH-1927N470SGGeneral Atomics Aeronautical Systems Inc · Poway, CAS/N GA-6-1557N479SGGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2024 · S/N GA-6-1592N47EPRum Bum Distributors Inc · Miami, FLBuilt 1978 · S/N 11520N47ZGJep Air LLC · Jackson, WYBuilt 1985 · S/N 42-5527031N480SGGeneral Atomics - Aeronautical Systems Inc · Poway, CABuilt 2024 · S/N GA-6-1635N483AFAir 1st Aviation Companies Inc · Aiken, SCBuilt 1973 · S/N 271N485AFLaver Michael · Glendale, AZBuilt 1974 · S/N 308N486MTNavy 8686 LLC · Boston, MABuilt 1985 · S/N 425527029N487AFAir 1st Aviation Companies Inc · Tyndall Afb, FLBuilt 1975 · S/N 333N487UEAircraft Propulsion Leasing LLC · Holland, OHBuilt 1990 · S/N 906N489AFLaver Michael · Glendale, AZS/N 243N48NPJere Aviation LLC · Fond Du Lac, WIBuilt 1981 · S/N 447 S.A.N496PTPlane Folk LLC · Klamath Falls, ORS/N AT-427N4NEP M Leasing Inc · Perris, CABuilt 1970 · S/N SH1885N4RRough Ryder Aircraft Inc · Carmel, NYBuilt 1981 · S/N 1542 S.A.N4WDHat Creek Aviation LLC · Hamilton, MTBuilt 1979 · S/N 399 S.A.N500ERConquest II LLC · Kenner, LABuilt 1979 · S/N 441-0084N500PJFly2mellc · Ooltewah, TNBuilt 1974 · S/N 668N5016HBest Aircraft Deals LLC · Salt Lake City, UTS/N 11452N502BRUS Leasing And Financial Inc · Wilmington, DEBuilt 1980 · S/N 4410135N502VAInternational Bank Of Commerce · Laredo, TXS/N 8135N505GMNc Hold 7 LLC · Raleigh, NCBuilt 1977 · S/N T286N507ZZAce Aviation LLC · Mankato, MNS/N 264N508FACbg LLC · Wilsonville, ORBuilt 1982 · S/N AC508N508PMTvc Av LLC · Jacksonville, FLBuilt 1984 · S/N 42-5527021N50DAP M Leasing Inc · Perris, CABuilt 1968 · S/N SH-1852N50DXYada Yada Yada Inc DBA · Fresno, CABuilt 1974 · S/N 11227N50EAEagle Air Transport Inc · Ottawa, ILBuilt 1968 · S/N SH1856N50KSedghi Reza · Macon, GABuilt 1974 · S/N 305N50LGUpham Chester R III · Mineral Wells, TXBuilt 1979 · S/N T315N510GRJohnson Lynn L · Grafton, NDBuilt 1997 · S/N G10-140
Back to AD 78-25-08 R3