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.

N11684Pepper Richard V · Henderson, TXBuilt 1972 · S/N 309-72N11686Hopewell Jeffrey D · Temple, TXS/N 310-72N11687Young William A · Delta Junction, AKBuilt 1972 · S/N 313-72N11690Evers William J · Sussex, WIBuilt 1972 · S/N 355-72N11693Miller Robert A · Auburn, CAS/N 853-72N11695Rvi Aviation LLC · Clay Center, KSBuilt 1972 · S/N 856-72N116PCGlobal Piloting Solutions LLC · Mankato, MNBuilt 2001 · S/N 1320-2001N116RAPreston William A · Benton Harbor, MIBuilt 2008 · S/N 1025-2008N116SDA L Aviation LLC · Boiling Springs, SCS/N 359-73N11702Tailwheeling It LLC · Algoma, WIBuilt 1972 · S/N 317-72N11704Jackman William L · Newman Lake, WAS/N 857-72N11706Hershberger Brian K · Wrightwood, CABuilt 1972 · S/N 319-72N11707Catfish Express Inc · Inverness, MSBuilt 1972 · S/N 15-72N11709Hutchins Reid C · Hanover, NHBuilt 1972 · S/N 859-72N11720Mcfarlane Kevin E · Dubuque, IABuilt 1972 · S/N 860-72N11721Yague-Martinez Eloy · Rochester, NYBuilt 1972 · S/N 320-72N1174EInman James Dylan · Parsons, TNS/N 1228-78N1174YWolfgram Gerald D · New Hope, MNS/N 11AC-1184N1175ENannini Gary S · Lincoln City, ORBuilt 1977 · S/N 314-77N1176EIrving Holdings LLC · Greensboro, NCBuilt 1977 · S/N 988-77N1177BTakacs John Paul III · Colorado Springs, COBuilt 1991 · S/N 651-91N1178EDills Timothy E DBA · Clymer, NYBuilt 1946 · S/N 7AC-4735N1178GAstarb John E · Baden, PAS/N 11AC-S25N1179EPlane Air LLC · Paducah, KYBuilt 1977 · S/N 1220-77N117CASfaf LLC · Meridian, MSS/N 1008-2007N117CPC P Aviation Inc · Santa Paula, CABuilt 1999 · S/N 1275-99N117SGPowell Ryan Christopher · Bozeman, MTS/N 1358-2004N117TMRegistered aircraftBuilt 2000 · S/N 874-2000N1184EHutchins Chad M · Colorado Springs, COBuilt 1977 · S/N 1217-77N11854Wildenberg Craig E · Menomonie, WIBuilt 1972 · S/N 825-72N11861Haga Kim E · Karlsruhe, NDS/N 829-72N11868Cornelius Joel D · Thief River Falls, MNBuilt 1972 · S/N 301-72N1186EHowatt Air Inc · Langdon, NDBuilt 1977 · S/N 257-77N11870Owens Eric D · Garland, TXBuilt 1972 · S/N 12-72N1187EEsterak David R · Boyce, LABuilt 1946 · S/N 7AC-4744N1189ERobert William F II · Rose Hill, KSBuilt 1946 · S/N 7BCM-4746N118AC9 Echo LLC · Muskogee, OKBuilt 1992 · S/N 672-92N118CBN118cb LLC · Westminster, MDBuilt 1969 · S/N 202N118SUSouthern Utah University · Cedar City, UTBuilt 2018 · S/N 522-2018N118TMHarper Jean · Centennial, COBuilt 2000 · S/N 1303-2000N11916Pleasure Air LLC · Lake Havasu City, AZBuilt 1946 · S/N 7AC-1508N1191ELawler Thomas O · Lava Hot Springs, IDBuilt 1946 · S/N 7AC-4748N1196ECofer Billie W · Double Oak, TXBuilt 1946 · S/N 7AC-4753N1197ECouch John Ainsley · Sealy, TXBuilt 1946 · S/N 7AC-4754N1199EThibodeaux Brian A · Eagle River, AKS/N 254-77N119BCW D Investments LLC · Sammamish, WAS/N 499-2007N119SGSantangelo Joseph A · Johnstown, NYBuilt 2002 · S/N 1329-2002N119SUSouthern Utah University · Cedar City, UTBuilt 2018 · S/N 523-2018N119TXJulicher Mark R · Bulverde, TXBuilt 1947 · S/N 7BCM-343N11BWQuonset Aviation LLC · North Kingstown, RIBuilt 1978 · S/N 434-78
Back to AD 2000-25-02 R1