AD 2000-25-02 R1

Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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.

N57674Benton Timothy C · Lepanto, ARBuilt 1973 · S/N 998-74N57676Arthur Flying Club Inc · Page, NDS/N 630-74N57677Dixie Dusters Inc · Itta Bena, MSBuilt 1974 · S/N 662-74N57678Flight School Inc · Spring, TXBuilt 1974 · S/N 417-74N57679Sw Aviation Services Inc · Queen Creek, AZBuilt 1974 · S/N 999-74N57682Cartillar James R IV · Wynne, ARBuilt 1973 · S/N 631-74N57683Legros Donald P · Jennings, LABuilt 1973 · S/N 632-74N57690Stockton Robert E · North Pole, AKBuilt 1974 · S/N 3-74N57691Heitz Joel L · Cozad, NEBuilt 1973 · S/N 418-74N57694Bishop David DBA · Butlerville, INBuilt 1973 · S/N 1000-74N580Aeroblayze Aviation LLC · Norman, OKBuilt 1972 · S/N 43-72N580JZumbrun Dennis L · Montz, LABuilt 1979 · S/N 580-80N580KG Force Air LLC · Columbus, OHBuilt 2012 · S/N 549-2012N58137K5 Aviation LLC · Las Vegas, NVS/N 7AC-5605N581DMTichy Thomas H · Albuquerque, NMBuilt 2002 · S/N 894-2002N585MAPadawan Labs LLC · Portland, ORBuilt 2005 · S/N 992-2005N587KBSwihart Painting LLC · Bolivar, MOBuilt 1978 · S/N 103978N587SMccomas William Joe · Humble, TXBuilt 2017 · S/N 587-2017N588BCSamela Nicholas V · Thomaston, CTS/N 564-2014N588DSCox Joshua · Ormond Beach, FLBuilt 1973 · S/N 961-73N5897X3 Hanging 9 Enterprizes LLC · Lewistown, MTS/N 7GCAA161MN58BHPierson Ted · Gooding, IDBuilt 2015 · S/N 568-2015N58NWAmerican Champion Aircraft Corp · Rochester, WIS/N 647-2026N58SAMacy Richard M · Lebanon, NES/N 1426-2007N59086Maxwell James B · Lewiston, IDBuilt 1973 · S/N 611-74N59133Barnes Robert B · Chico, CABuilt 1946 · S/N 7AC-1310N5923LKane Christopher M · Sacred Heart, MNS/N 7GC-80N592RJWood Roger E · Waxhaw, NCBuilt 1969 · S/N 702N594AMMaarouf Mike · Taylor Lk Vlg, TXS/N 243-76N595ACBordlemay John J · Lewisberry, PABuilt 1999 · S/N 834-99N596JRWilliams David J · San Francisco, CAS/N 1359-96N597CMAerospace Trust Managment LLC Owner Trustee · Wilmington, DEBuilt 2013 · S/N 1130-2013N597GCAg-Av8r Flying Services LLC · Brookline, NHBuilt 1959 · S/N 7GC-72N5994BGunning Craig H · Lansford, NDS/N 7BCM-261N599DKEngler Jerry J · Kerrville, TXBuilt 1999 · S/N 419-99N599SIron Pillar Properties Inc · Falkville, ALS/N 7FC-462N59ACWatson David A · San Jose, CABuilt 1995 · S/N 747-95N59LAAlphin Lewis Jackson · Mount Olive, NCBuilt 1999 · S/N 430-99N59MSSojka Michael J · Bainbridge, INBuilt 1994 · S/N 735-94N59WDHorner Michael W · Manakin Sabot, VABuilt 2007 · S/N 1423-2007N59WLHerrmann Mark D · Dillingham, AKS/N 269-70N59ZRiggs Craig A · Collinsville, OKS/N 7BCM-93N5BJLinrud Michael A · Velva, NDBuilt 1969 · S/N 187N5FNM J S Corp · Howe, INBuilt 2013 · S/N 1468-2012N5JSRagwing Flying Club LLC · Des Allemands, LABuilt 1946 · S/N 7AC-5778N5KDTexas Tailspin LLC · Amarillo, TXBuilt 1974 · S/N 155-74N5TEBythway William M · Painesville, OHBuilt 1968 · S/N 113N600BCRitch Steve · Baker City, ORBuilt 2014 · S/N 563-2014N600GGNlh Aviation LLC · College Station, TXBuilt 1980 · S/N 394-80N600PCRudd Wayne · Basalt, COBuilt 1993 · S/N 714-93
Back to AD 2000-25-02 R1