OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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.

N30889Abbott Michael S · Radford, VABuilt 1970 · S/N 17701527N30892Salvagnini David R · Falls Church, VABuilt 1970 · S/N 17701529N30894Hartacres LLC · Kalispell, MTBuilt 1970 · S/N 17701531N308BCMike Kilo Foxtrot LLC · Wilmington, DEBuilt 1979 · S/N 21063618N308DW8dw LLC · Glendale, CABuilt 1985 · S/N 15285940N308FWLlb Enterprises LLC · Des Moines, WABuilt 1981 · S/N 24-1212N308KS J Fox Farm LLC · Corning, ARBuilt 2012 · S/N 552-2012N308SUHagele Aviation LLC · Hillsboro, ORBuilt 1981 · S/N 17275027N308TATrinity Aviation LLC · Georgetown, TXBuilt 2001 · S/N 453-2000N30900Pouilaitis William G · Landing, NJBuilt 1970 · S/N 17701536N30909Page Steven C · Porterville, CAS/N 17701540N30918Duepner Greg D · Georgetown, TXBuilt 1970 · S/N 17701545N30925Davis Jerold W · Fallbrook, CABuilt 1970 · S/N 17701549N30928Kellner Donald · Attica, NYBuilt 1970 · S/N 17701550N30934Happy Bottom Flying Club · Griggsville, ILBuilt 1970 · S/N 17701551N30935Peterson Air LLC · Chisago City, MNBuilt 1970 · S/N 17701552N30936Wilcox Gary C · Dansville, MIBuilt 1970 · S/N 17701553N30938Virginia Aviation LLC · Forest, VAS/N 17701554N30939Lee Richard B · Wasilla, AKBuilt 1970 · S/N 17701555N3093EBrown Joseph M · Kansas City, MOBuilt 1978 · S/N 17271440N30940Qualitair LLC Trustee · MicahelstadtBuilt 1970 · S/N 17701556N30941Clausnitzer Douglas L · Apple Valley, MNBuilt 1970 · S/N 17701557N30945Hawkins Cody · Englewood, COBuilt 1970 · S/N 17701560N30946Goldstein Jonathan D · Freehold, NJBuilt 1970 · S/N 17701561N30965Monkey Boy Aviation LLC · Palm Coast, FLS/N 17701571N30966Walker Jeffrey Scott · Winchester, TNBuilt 1970 · S/N 17701572N30967Stormy Cat Inc · Wilmington, DEBuilt 1970 · S/N 17701573N30974Sullivan Michael J · Gilroy Ca, CABuilt 1970 · S/N 17701576N30977Shearer David L · Crossville, TNBuilt 1970 · S/N 17701577N30979Atlantic Pacific Marketing Inc · Berlin, MDBuilt 1970 · S/N 17701579N30988Swisher James M · San Marcos, TXBuilt 1970 · S/N 17701584N30990Rozzell Scott E · Houston, TXBuilt 1970 · S/N 17701585N30994Webb Jason S · Midlothian, TXBuilt 1970 · S/N 17701588N309LLSweepyacres LLC · Greenbrier, TNS/N 177RG1346N309MMDavenport James M II · Hollywood, FLBuilt 1975 · S/N 17265518N30EGPlane Fun Inc Tr Trustee · Snellville, GAS/N 345N30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeBuilt 1982 · S/N R18201913N30FMM20j LLC · Niceville, FLBuilt 1997 · S/N 24-3410N30GSClausen Robert G · Argyle, MNBuilt 1973 · S/N 17261470N30HDRegistered aircraftS/N 21063234N30JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17268043N30PCHaas Brent R · Willcox, AZBuilt 2026 · S/N 1492-2026N30RHHalye Roger J · Port Orange, FLBuilt 1977 · S/N 17269998N30SBFlare LLC · Chattanooga, TNBuilt 2004 · S/N 955-2004N30VGGeoterra Inc · Eugene, ORBuilt 1980 · S/N 21063856N30WHAcme Aerosports Inc · Huntsville, ALBuilt 1977 · S/N 997-77N3104TBrobst David D · Durango, COS/N 17700404N3105TColburn Lant R · Cleburne, TXBuilt 1967 · S/N 17700405N3107PRonald Waldron · Strongsville, OHBuilt 1979 · S/N 17272223N3107TRichardson Kroy · Littleton, COBuilt 1967 · S/N 17700407
Back to AD 80-25-07 R1