OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,560

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.

N179PCMsb Aero LLC · Middletown, DES/N 1029-2006N179RAMorter Roger P · Hermiston, ORBuilt 2004 · S/N 1352-2003N17BYSudac Ivan · Boise, IDBuilt 2004 · S/N 945-2004N17JCHigh Wing Aviation LLC · Sardis, MSBuilt 1969 · S/N 164N17KHHubatch Kenneth A · West Bend, WIBuilt 1991 · S/N 646-91N1802EViau Robert · Fresno, CABuilt 1946 · S/N 7AC-5369N1803GCarolina Aero Group LLC · Youngsville, NCBuilt 1968 · S/N 544N1804GKrenzke Stephen E · Fairbanks, AKBuilt 1968 · S/N 100N1805ENeander Steven A · Lodi, WIS/N 7AC-5372N1805GWilliams Roger A · Langford, SDBuilt 1968 · S/N 559N1806GAmelia Reid Aviation LLC · San Jose, CABuilt 1968 · S/N 573N1807ELorobsco LLC · Cavour, SDBuilt 1946 · S/N 7AC-5374N1807GCj Mosman & Son · Nezperce, IDS/N 565N1808GFleming Tod E · Davenport, WABuilt 1968 · S/N 570N1809GBerardi Christopher · Crowley, TXBuilt 1968 · S/N 571N180CGBailey Bendrix · Rochester, MABuilt 2002 · S/N 434-2002N180LARonsman Harry M · Talkeetna, AKBuilt 1994 · S/N 368-94N180SDMoore Philip R · Thompsons Station, TNBuilt 1975 · S/N 219-76N1810EWof Aero Ltd · Tipp City, OHBuilt 1946 · S/N 7AC-5377N1811EEndres Sam D · Gainesville, TXBuilt 1946 · S/N 7AC-5378N1811GYelle Flyers LLC · Cashion, OKBuilt 1968 · S/N 584N1813EWilkins Daniel T · Portland, PABuilt 1946 · S/N 7AC-5380N1813GSenior Flyers LLC · Kalamazoo, MIBuilt 1968 · S/N 596N1817GJacelon Charles E · Little River, SCBuilt 1968 · S/N 409N1818EAlbij3 LLC · Milton, FLBuilt 1946 · S/N 7AC-5385N1818GPine Wind Aviation LLC · San Francisco, CABuilt 1968 · S/N 561N1819DSpeedcraft Industries LLC · Port Jefferson, NYBuilt 2020 · S/N 1188-2020N181RAPinkowski Richard · Marcellus, NYBuilt 1993 · S/N 719-93N181TMEichhorn Scott William · Searcy, ARS/N 114-74N1822EEngel Carson D Trustee · Amboy, INBuilt 1946 · S/N 7AC-5389N1822GWhr Sales LLC · Riviera Beach, FLBuilt 1968 · S/N 187N1824ECoulter Timothy H · Vineland, NJBuilt 1946 · S/N 7AC-5391N1826GSelting Mark D · Kadoka, SDBuilt 1968 · S/N 102N1827GSpangler Anthony J · Bethel, AKBuilt 1968 · S/N 587N1828Van Nice Alexander W · Wasilla, AKS/N 101N1830EMeyer Scott David · Plano, TXBuilt 1946 · S/N 7AC-5397N1831EBacon Joseph M · Fenton, MIBuilt 1946 · S/N 7AC5399N1831GGee3 LLC · Sardis, MSBuilt 1968 · S/N 600N1832GThomas Robert D Jr · Tulsa, OKS/N 86N1833ETerry Michael R Trustee · Santa Paula, CABuilt 1946 · S/N 7DC-5400N1834EHurley G Jay · Shepherdstown, WVBuilt 1946 · S/N 7AC-5401N1836GJensen Steven M · Tioga, NDBuilt 1968 · S/N 595N1838GNickelson Gene A · Weskan, KSBuilt 1968 · S/N 188N183ACSynnes Mark A · Halliday, NDS/N 728-94N183RAYaggie Allen · Wahpeton, NDBuilt 2005 · S/N 1396-2005N1840EWebb Richard C · Milford, DES/N 7AC-5407N1840GJulicher Mark R · Bulverde, TXBuilt 1968 · S/N 79N1841EAeronca Flying Club Inc · Winchester, VABuilt 1946 · S/N 7AC-5408N1842GOwen Dean W · Morehead, KYBuilt 1968 · S/N 585N1843GWincar Air LLC · Doniphan, NEBuilt 1968 · S/N 78
Back to AD 2000-25-02 R1