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.

N4115YN4115y LLC · Munday, TXS/N 948-76N41171Wilco Aviation LLC · Jonesboro, ARS/N 735-70N4117YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 592-76N4119NJohnson Cherryl A · Cadillac, MIBuilt 1968 · S/N 680076N4119YSmith Robert R · Benton, LAS/N 276-76N411DKSwaz Aviation LLC · Mesa, AZS/N 17260703N411DWKibler Joseph T · Mount Airy, MDBuilt 1996 · S/N 772-96N411LRHensley Ty · Lake Wylie, SCBuilt 1992 · S/N 679-92N411SSDalmolin Russell Scott · Globe, AZBuilt 1973 · S/N 17261603N411TSTango Sierra Aviation Inc · Stuart, FLBuilt 1979 · S/N R18201198N411YSky Pirate LLC · Provo, UTBuilt 1977 · S/N 326-77N4120NBurr Eugene F Jr · Lugoff, SCS/N 680037N4121YStotts Jimmy W · Jonesboro, ARBuilt 1976 · S/N 1176-76N4122HBeck Randy R · Claremont, CABuilt 1978 · S/N 24-0645N4122YPetter David · Stuttgart, ARBuilt 1976 · S/N 333-76N4124HTyler Patrick E · Poplar Grove, ILBuilt 1978 · S/N 24-0637N4124YConsolidated Aviation Services LLC · Seymour, TNBuilt 1976 · S/N 593-76N4125HOsterbeck Jeffrey A · Jackson, WIBuilt 1979 · S/N 24-0771N4126PPorebski Peter T · New Port Richey, FLBuilt 1975 · S/N 17702320N4128HLehnert Jaxon C · Turpin, OKBuilt 1978 · S/N 24-0642N412HMCain Ryan C · Beaumont, CABuilt 1975 · S/N 20-1163N412KBBlagg Kevin B · Dumas, ARBuilt 2005 · S/N 476-2005N412KJTudor Jeff · Orlando, FLBuilt 1978 · S/N R18200464N412MRMundy Mark · Cape Coral, FLBuilt 1968 · S/N 680163N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310N4132YMartin Beaux R · Calhoun, LAS/N 234-76N4134YLandon Jeff · Quartz Hill, CAS/N 278-76N4135YMoore Steven J · West Ossipee, NHBuilt 1976 · S/N 953-76N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566N4138HMiller John A · Ballston Lake, NYBuilt 1978 · S/N 24-0643N4139YPremier Management Co Inc · Mobridge, SDBuilt 1978 · S/N 1248-78N413EBG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0113N413HMDouble A Aviators LLC · Taylors, SCBuilt 1975 · S/N 21-1179N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164N413WPKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1261-99N413YKGoodner Terry Jack · Port Saint Lucie, FLS/N 818N4140YBuckman Dean D · Monroe City, MOBuilt 1976 · S/N 1178-76N4141KKimminau Jeremy · Sacramento, CABuilt 1967 · S/N 680006N4141YWells Kevin R · Elko, NVBuilt 1976 · S/N 1179-76N4142YRegistered aircraftBuilt 1976 · S/N 279-76N4143YHasenfus Heidi J · Green Cove Springs, FLBuilt 1977 · S/N 236-77N4147YReisdorf Steven R · Saint Cloud, MNBuilt 1976 · S/N 956-76N4148CMjolhus Knut G · Amarillo, TXBuilt 1978 · S/N R18200329N4148HRegistered aircraftBuilt 1978 · S/N 24-0647N4148YTailwheel Flying LLC · Rochester, MNBuilt 1976 · S/N 280-76N414FHSewell Stephen A · Navasota, TXBuilt 1980 · S/N R18201639N4150YFlying Bullfrog LLC · Virginia Beach, VABuilt 1976 · S/N 597-76N4151YWarner Kenneth G · Granbury, TXBuilt 1976 · S/N 1181-77N4152HMountain West Aviation LLC · Denver, COBuilt 1979 · S/N 24-0770
Back to AD 80-25-07 R1