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.

N396ACMayfly Aviation LLC · Quincy, FLBuilt 2002 · S/N 895-2002N396BGLow And Slow Flyers LLC · Urbandale, IAS/N 1216-96N396SKIal Corp · Lewes, DES/N 17274143N3970HWheeler Martin C · Eden Prairie, MNS/N 24-0997N3970NBrown Roland T · Raymond, MSS/N 680071N3970QPetree James D · Asotin, WABuilt 1971 · S/N 17260070N3971NBravo Aviation LLC · Rexburg, IDBuilt 1968 · S/N 680010N3972QStiles Thomas · Mechanicsville, VABuilt 1971 · S/N 17260072N3973QIdg Elsa LLC · Ann Arbor, MIBuilt 1971 · S/N 17260073N3975QBrachtenbach Eric L · Hill City, KSS/N 17260075N3977NKelley Daniel P · Newton, ALBuilt 1968 · S/N 680151N3977QLabanoski Mark B · Hornell, NYS/N 17260077N3978PNicklas William T · Rllng Hls Est, CABuilt 1977 · S/N 15279647N3978QDv Aircraft Leasing · Green Bay, WIBuilt 1971 · S/N 17260078N3979QCarey International Aviation Services LLC · Rockville Centre, NYBuilt 1971 · S/N 17260079N397RDGlover Michael · Parker, TXS/N 533-2010N397TNickerson Kelly D · Ellensburg, WABuilt 1973 · S/N 17260863N3980QLanning 1 Aviation LLC · Amarillo, TXBuilt 1971 · S/N 17260080N3982QSouther Field Aviation Inc · Americus, GABuilt 1971 · S/N 17260082N3984NSpencer Aviation Inc · Delaware, OHBuilt 1968 · S/N 680012N3984QYarrington David W · Magnolia, DEBuilt 1971 · S/N 17260084N3985Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1982 · S/N 17275841N3985NRobinett Christopher T · Oklahoma City, OKBuilt 1968 · S/N 680152N3985QArnold Ralph F · Golden Valley, AZBuilt 1971 · S/N 17260085N3986QMfv-N5498q Owners Association Inc · New Church, VABuilt 1971 · S/N 17260086N3987NCascadia Software Inc · Puyallup, WABuilt 1968 · S/N 680153N3988NSchmeltz Sterling D · Ocala, FLBuilt 1968 · S/N 680014N3989NOlson Michael J · Grand Island, NYBuilt 1968 · S/N 680154N3989QDms Leasing Co LLC · Las Vegas, NVBuilt 1971 · S/N 17260089N398AGShin Howard I · New York, NYBuilt 2008 · S/N 1079-2008N398BCNorthwest Back Country Aircraft LLC · Caldwell, IDBuilt 2026 · S/N 1231-2026N398GLembo Daniel A · North Syracuse, NYBuilt 1981 · S/N 24-1115N398GBBennett Robert A · Wagener, SCBuilt 1981 · S/N 17274736N398SBYuba Sutter Aviation Inc · Olivehurst, CABuilt 1998 · S/N 821-98N3990HLasar Inc · Prineville, ORS/N 24-1001N3992NBoehm Justin K · Cleveland Heights, OHS/N 680016N3994NJohnson Gregory H · Thousand Oaks, CABuilt 1968 · S/N 680156N3996NSumner Thurston B III · Ocracoke, NCBuilt 1968 · S/N 680017N3996QLuther Turner S · Perry, FLBuilt 1971 · S/N 17260096N3997NStevens James A · Acworth, GABuilt 1968 · S/N 680157N3997QMurray Edward K · Fallbrook, CABuilt 1971 · S/N 17260097N3999YSlyman David F · Inver Grove, MNBuilt 1969 · S/N 7KCAB-225N399BCParadox Aviation LLC · Whiting, IABuilt 1999 · S/N 423-99N399BZBerjon Adventures LLC · Evergreen, COBuilt 2020 · S/N 607-2020N399JPL&M Aircraft Inc · Rome, GABuilt 1977 · S/N 177RG1111N39BEAberdeen Flying Service · Aberdeen, SDBuilt 1984 · S/N 21064889N39CFFedrigo John A · Moneta, VAS/N 38-79A0765N39DBKwasinski Mark W · Kalamazoo, MIBuilt 1969 · S/N 153N39JLLundberg Jonathan S · Fayetteville, TNBuilt 2012 · S/N 1115-2012N39LTGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 924-2003
Back to AD 80-25-07 R1