OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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.

N191PSRegistration Pending · El Dorado Springs, MORegistration pendingBuilt 1994 · S/N 996N1926GJaju Aviation Inc · Abilene, TXBuilt 1974 · S/N 1026-74N192FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1985 · S/N 15285979N1930SDart Gregory G · Mayville, NYS/N NS001N193BAVonheeder Jasen T · Newport Center, VTBuilt 1978 · S/N 38-78A0083N1941KBalser Joe · Lafayette, INBuilt 2017 · S/N 339N194BJordan Allen D · Choudrant, LABuilt 2018 · S/N 0022N194BAUnruly Passengers LLC · Piedmont, SCS/N 38-82A0063N194JBPollard Chad J · San Jose, CABuilt 1998 · S/N JB2N194TNicholson Earl J · New Milton, WVBuilt 1953 · S/N 18-2308N195DBBarton Douglas E · Woodland, CABuilt 1972 · S/N 2N195THandyside Bryan P · Duluth, MNBuilt 1953 · S/N 18-2309N1967KAir-Ag Inc · Tarboro, NCBuilt 1947 · S/N 11-1523-201N1967TSloan Jeffrey Sterling · Hazen, ARBuilt 1967 · S/N 543N1970YCrosby A B Jr · Devine, TXBuilt 1970 · S/N AA10240N1972AConkle Marc · Madera, CABuilt 1972 · S/N AA1A-0417N197BFGray Shane Charles · Interlochen, MIBuilt 1997 · S/N 019N197THN197th LLC · Sammamish, WABuilt 1977 · S/N 15280093N1984ZLynx Aviation Inc · King Salmon, AKBuilt 1973 · S/N 912-73N198JTRibeiro Brian C · Clovis, CABuilt 1995 · S/N 1357-95N198RSHanna David B · Tonasket, WAS/N RJS-001N1996XRegistered aircraftBuilt 1978 · S/N 38-78A0777N199RWRush Casey K · Troy, KSBuilt 1991 · S/N REW-01N19BTAkin Christopher J · Port Saint Lucie, FLBuilt 1975 · S/N BJT-1N19LEZamber Jon · Medina, TNS/N 1341N19MYCamino Thomas J · Buffalo, WYBuilt 1946 · S/N 12-2274N1AHHenley Alan F · Hoover, ALBuilt 1977 · S/N 1372-15N1CQMuller Gustavo · Spanish Fort, ALS/N AA1B-0158N1EPSowders Darwin G · Robinson, TXBuilt 1976 · S/N 18N1LZBlock Scott M · Chandler, AZBuilt 1991 · S/N 1110N1SETin Cup Aviation LLC · Lakeland, FLBuilt 1947 · S/N 12-2036N1WRRyan William R · Jupiter, FLS/N 1845N1ZZAnderson Jacob D · Algona, IABuilt 1966 · S/N 347N2004HMolek Jon · Warren, OHS/N F-1004N2004VLindeman Jack E · Berlin, NYBuilt 1980 · S/N F-1007N2004YAmorelli Leon D · River Falls, WIBuilt 1980 · S/N F-1008N2005EShaw Brian W · Bemidji, MNBuilt 1981 · S/N F-1015N2005JGray Shane Charles · Interlochen, MIS/N F-1014N2005KBiornstad John A · Big Lake, AKBuilt 1981 · S/N F-1016N2005UArcand David R · Forest Lake, MNBuilt 1981 · S/N F-1013N2005ZKornstad Vern A · Kenai, AKBuilt 1982 · S/N F-1018N2006CPankratz David · Frazer, MTBuilt 1982 · S/N F-1501N2006JGlendinning William O · South Bristol, MEBuilt 1982 · S/N F-1021N2006LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1982 · S/N F-1500N2006SSchimenek Richard J · Cloquet, MNS/N F-1502N2006UAllred Robert B · Anthem, AZBuilt 1983 · S/N F-1020N200ZALawrence James D · Woodbridge, VABuilt 1995 · S/N 20-0003N2019LReavis William B · Yadkinville, NCBuilt 2024 · S/N 75-7610N2020BLepkowski Daniel P · Industry, PABuilt 1948 · S/N 6447N2024NCrow Edward N · Silverdale, WABuilt 1947 · S/N 12260
Back to AD 80-25-02 R2