OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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-02-R2')
    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-02-R2')
  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.

N4207MLessley Aviation LLC · Carrollton, MSBuilt 1947 · S/N 12-3100N4208HDahmes Bradley M · Hawick, MNBuilt 1948 · S/N 14-12N4209MWahl Joseph Lewis · Elizabeth, COBuilt 1947 · S/N 12-3104N4209YShilt Jerry C · El Dorado Springs, MOBuilt 1977 · S/N 1197-77N4210HGage Ricky Duane · Lewiston, IDBuilt 1948 · S/N 14-13N4211MMccartan Gary M · Pocahontas, IABuilt 1947 · S/N 12-3106N4211NTaylor Dale W · Cape Fair, MOBuilt 1947 · S/N 13682N4212MMiller Taylor Robert Mamouney · North Bend, ORBuilt 1947 · S/N 12-3107N42138Cape May Aerial Advertising LLC · Rio Grande, NJS/N 14364N4213HWiese Ryan Mark · Eagle River, AKBuilt 1948 · S/N 14-16N4213MNatale William F · Saratoga Springs, NYBuilt 1947 · S/N 12-3108N4214YAngran Nate J · Albia, IABuilt 1977 · S/N 1199-77N42166Snyder Jon · Charlotte, NCBuilt 1945 · S/N 14401N42183Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1945 · S/N 14425N4218MFordyce Gregory L · Gaston, ORBuilt 1947 · S/N 12-3114N4222MRoberts Alan Wayne · Emmetsburg, IAS/N 12-3118N4223MMccrory John D · Marfa, TXBuilt 1947 · S/N 12-3119N4224HWharton William R Jr · Dresden, OHBuilt 1978 · S/N 152-80324N4226HAngel Aviation Inc · Peoria, AZS/N 14-29N4227MVogt Thomas Earl · Cedarburg, WIBuilt 1947 · S/N 12-3124N4228ETomahawk 4228e LLC · Tucson, AZS/N 38-78A0497N42297Karel Benjamin R · Stillwater, MNBuilt 1945 · S/N 14547N422CJSmith Jason W · Clarksville, TNFirst renewal noticeBuilt 1998 · S/N 537N422JPWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284589N4231MHarloff David F · Lehigh Acres, FLBuilt 1947 · S/N 12-3129N4232MHardy Willard H Jr · Lincolnville, MEBuilt 1947 · S/N 12-3128N4233MJordan Lee · Dickinson, TXBuilt 1947 · S/N 12-3177N4236MLehman Robert J · Marissa, ILS/N 12-3132N4238MRobinson Eric C · Palmer, AKBuilt 1947 · S/N 12-3134N42399Reece Rebecca H · San Angelo, TXS/N 14658N4245MThornley Timothy C · Anchorage, AKBuilt 1947 · S/N 12-3138N4249MHassell Dan J · Ketchikan, AKBuilt 1947 · S/N 12-3143N424MKMkt Aviation LLC · Mankato, MNBuilt 1978 · S/N 15281808N424RBMuse Raymomnd P · Nacogdoches, TXBuilt 1996 · S/N 018N4251ERobbins Warren N · Chandler, AZBuilt 1978 · S/N 38-78A0507N4251MChapin Dean H · Cambridge, NYBuilt 1947 · S/N 12-3145N4252HHoutz Allen D · Kenai, AKBuilt 1948 · S/N 14-55N4252MRobinson Eric C · Palmer, AKBuilt 1947 · S/N 12-3146N4257MBaus Roman J · Rubicon, WIBuilt 1947 · S/N 12-3151N425AHHanson B Jake · Jackson, WYBuilt 1946 · S/N 12-817N425MKNorth Star Aviation Inc · Mankato, MNBuilt 1977 · S/N 15280650N4260MHelmstadt Ronald J · Bridgeport, MIBuilt 1947 · S/N 12-3176N4262MHoech Neal L · Everett, WABuilt 1947 · S/N 12-3175N4263MThompson Frank Link · Gordon, NEBuilt 1947 · S/N 12-3178N4267ERmd Enterprises LLC · Rockwall, TXBuilt 1978 · S/N 38-78A0515N4267MMurphy Aaron S · Girdwood, AKBuilt 1947 · S/N 12-3196N4270HShields Edwin G · York, SCBuilt 1948 · S/N 14-75N4275EAllison Larry J · Villa Rica, GAS/N 38-78A0521N4275MHicks Joseph O · Germanton, NCBuilt 1947 · S/N 12-3203N4276HTailwind Aviation Inc · Wasilla, AKBuilt 1948 · S/N 1480
Back to AD 80-25-02 R2