OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,367

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.

N12732Fly By Knight Inc · Wilmington, DEBuilt 1973 · S/N 17262213N12733Rodriguez James M · Alamo, CABuilt 1973 · S/N 17262214N12736Pumpkin Eater LLC · Tavares, FLS/N 17262217N12737Nageotte Randy K · Fredericksburg, VABuilt 1973 · S/N 17262218N127381928 LLC · Dillon, MTBuilt 1973 · S/N 17262219N1273UDifazio Santo P · Sahuarita, AZBuilt 1976 · S/N 17266968N12740Bjorlie Paul · Pekin, NDBuilt 1973 · S/N 17262220N12741Wings Of Man Ltd · Wauwatosa, WIBuilt 1973 · S/N 17262221N12745Gutierrez Benito E · Tehachapi, CABuilt 1974 · S/N 17262224N12749Daly Paul Kurt Jr · Yucaipa, CABuilt 1973 · S/N 17262228N1274UVine Clayton A · Wolf Point, MTBuilt 1976 · S/N 17266969N12750Crosby Flying Services LLC · Fort Worth, TXBuilt 1973 · S/N 17262229N12751Wyatt Trost LLC · Concordia, KSBuilt 1973 · S/N 17262230N12753Juliett Papa LLC · Kalispell, MTBuilt 1973 · S/N 17262232N12760Decker Stephen Lee · Como, COBuilt 1973 · S/N 17262235N12766Civil Air Patrol Flying Assoc Inc · Branford, CTBuilt 1973 · S/N 17262240N12767Lipstreu William H · Hudson, OHBuilt 1975 · S/N 17702386N12768Martin Thomas J · Lynden, WABuilt 1973 · S/N 17262242N1276UStelham Co · Olive Branch, MSBuilt 1976 · S/N 17266971N12772Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1973 · S/N 17262245N12776Oviedo Juan · Oak Point, TXBuilt 1973 · S/N 17262249N12777Mana Kai Flying LLC · Makawao, HIBuilt 1973 · S/N 17262250N12779Mile High Flyers Club Inc · Fort Valley, VABuilt 1973 · S/N 17262252N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150N127826350 LLC · Yorklyn, DES/N 17702387N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267N1279XRegistered aircraftBuilt 1963 · S/N 152N127BDRegistered aircraftBuilt 2022 · S/N 620-2022N127EDRussell Robert Q · Genoa City, WIBuilt 1980 · S/N 15284797N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481N127FRYoon Paul · Saint David, AZS/N 17275292N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210N127SAVintage Tailwheel LLC · Wilmington, DEBuilt 2006 · S/N 1026-2006N127TMPlane Air LLC · Paducah, KYBuilt 2001 · S/N 427-2001N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275N1280XErlandson Michael D · Salt Lake City, UTS/N 153N12819Stewart Todd L · Mooresville, NCS/N 17262288N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291N1282URutledge James K Trustee · Colfax, CABuilt 1976 · S/N 17266977
Back to AD 80-25-07 R1