OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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.

N7481GUncapher Elmer D · Mendon, OHS/N 17259181N7485GIndependent Aviation Services LLC · Sachse, TXBuilt 1970 · S/N 17259185N7487GRich Aviation Services LLC · Fort Worth, TXBuilt 1970 · S/N 17259187N7489GCloud Fleet Aviation LLC · Fort Lauderdale, FLBuilt 1970 · S/N 17259189N748ACSweeet Aviation LLC · Dover, DEBuilt 1999 · S/N 847-99N748LLdz Aviation Resources LLC · Sayville, NYBuilt 1976 · S/N 0748N7491GAccess Air Service Inc · Mercedita, PRBuilt 1970 · S/N 17259191N7493GHaugo Robert P · Scobey, MTBuilt 1970 · S/N 17259193N7499CHillsboro Flying Club · Hillsboro, ORBuilt 1981 · S/N 17274992N749PCGreen Hornet Aviation LLC · Washington, DCBuilt 1995 · S/N 742-95N749PJAgl Aviation And Management LLC · Payson, AZBuilt 2017 · S/N 581-2017N749SKOcean Aerial Ads Inc · Berlin, MDBuilt 1974 · S/N 127-75N74CPersonal Aviation Inc · Poway, CABuilt 1978 · S/N 17270368N74CDMcburney & Associates LLC · Horseshoe Bay, TXBuilt 2003 · S/N 909-2003N74DMT C Rian Association LLC · Grove, OKBuilt 1973 · S/N 17262699N74DPRegistered aircraftBuilt 1974 · S/N 17702150N74ERSimplifly LLC · Mesa, AZBuilt 1977 · S/N 17269502N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279N74JPGulf Coast Helicopters Inc · Pearland, TXBuilt 1974 · S/N 17263356N74NANelson Kenneth · Caledonia, WIBuilt 2005 · S/N 1399-2005N74PESkycrafters Incorporated · Johnson City, TNBuilt 1973 · S/N 17262191N74PKRegistered aircraftBuilt 1974 · S/N 21-0035N74PPBunnell Randy D · Blakesburg, IABuilt 1968 · S/N 17700928N74SSPelletier Kevin C · Williamsport, MDBuilt 1974 · S/N 177RG0530N7500FGrindley John E · Hopewell Junction, NYBuilt 1969 · S/N 214N75013Frank Technologies Inc · Venice, CAS/N 17272705N7501FStafford Tech Inc · Rehoboth, MABuilt 1969 · S/N 204N7502FBarrie Lorna D · Tonawanda, NYBuilt 1969 · S/N 713N7502VBluewater Bay LLC · Ardmore, OKBuilt 1975 · S/N 177RG0801N7503FPatton David · Elmendorf, TXBuilt 1969 · S/N 714N7503VChuga Gregory M II · Hayes, VAFirst renewal noticeBuilt 1976 · S/N 177RG0802N7504FDerr Michael K · Maitland, MOBuilt 1969 · S/N 715N7504VImage Craft LLC · Phoenix, AZBuilt 1975 · S/N 177RG0803N7505FIpme Management Corp · Jefferson, GABuilt 1969 · S/N 716N7505VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 177RG0804N7506FOklahoma Airmen Flying Club Inc · Jenks, OKBuilt 1969 · S/N 717N7507FThomson Mary Ellen · East Berlin, PABuilt 1969 · S/N 718N750YTwo Bar Aviation Inc · Lincoln, NES/N 17263139N7510FGrand Canyon Flyers LLC · Flagstaff, AZBuilt 1969 · S/N 719N7511FEisenbrey Glen T · Greenbank, WABuilt 1969 · S/N 720N7512FCulver Marc D · Anchorage, AKBuilt 1969 · S/N 722N7513FFrank Jerry W · Vonore, TNBuilt 1969 · S/N 723-70N7515VRxair 2 Inc · Bella Vista, ARS/N 177RG0812N7516FMahan Phillip A · Juneau, AKBuilt 1969 · S/N 198N7516VOgletree Ben R Jr · Livingston, TXBuilt 1975 · S/N 177RG0813N7517VSims Albert Paul · Auburndale, FLBuilt 1975 · S/N 177RG0814N7518FKlassen Orvil H · Mountain Lake, MNS/N 200N7519FBohlman Todd L · Lemon Grove, CABuilt 1969 · S/N 201N751BKGeneral Aviation LLC · Henderson, NVBuilt 1978 · S/N 17270335N751DWGaskins Frank E · Ashland, VABuilt 1981 · S/N 172RG1002
Back to AD 80-25-07 R1