OpenAirDocs.org
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.

N55JJPrivitt Bret · Fort Worth, TXBuilt 1974 · S/N 311-75N55VMSpurr Richard R · Bloomfield, NYBuilt 2020 · S/N 610-2021N56035Schindler Nick E · Neligh, NES/N 276-78N560MBCorrigan Patrick · Hondo, TXS/N 1009-74N561DMMorgan John · Jonesville, LAS/N 428-2001N561PWestern Farming LLC · Missoula, MTBuilt 2006 · S/N 485-2006N561SDAugspurger David R · Seneca, SCBuilt 1979 · S/N 564-79N562BAAviation Financial Corp · Torrance, CABuilt 2005 · S/N 1012-2005N563TWalker Aviation LLC · Andover, KSS/N 1462-2011N563WSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 995-2005N564MAIndia Charlie Alpha Aviation LLC · Missoula, MTBuilt 2005 · S/N 989-2005N565MAM & M Aviation LLC · Memphis, TNBuilt 2005 · S/N 987-2005N565TEcho Baravo LLC · Geneva, ILBuilt 2024 · S/N 639-2024N567ECStaudacher Mark W · Bay City, MIBuilt 1956 · S/N 7EC-483N567PCMateri Lori A · Upton, WYBuilt 2006 · S/N 1419-2006N568BCN28179 Inc · West Gilgo Beach, NYBuilt 2024 · S/N 644-2025N569TSBig South Fork Aero Inc · Huntsville, TNBuilt 1993 · S/N 722-93N56LHSchunk Luke C · Lake Tomahawk, WIBuilt 1956 · S/N 7EC390N56SJShaw Kenneth F · Redding, CABuilt 1999 · S/N 1267-99N56WGErickson Lynn A · Prairie Du Sac, WIBuilt 2018 · S/N 1474-2018N570CAMidwest Aviation Inc · Mayfield, KYBuilt 2010 · S/N 528-2010N570MATuminello Joseph A · San Francisco, CABuilt 2005 · S/N 496-2005N571BMAasjng LLC · Holdrege, NEBuilt 2007 · S/N 1042-2007N571DMWilliams Stephen C · Georgetown, MEBuilt 2002 · S/N 464-2002N571LFRegistered aircraftBuilt 2003 · S/N 478-2003N571SARegistration Pending · Azle, TXRegistration pendingBuilt 2005 · S/N 1009-2005N57383Dalley Robert C · Waldron, INBuilt 1973 · S/N 936-73N57385Victor Foxtrot LLC · Scott City, KSBuilt 1973 · S/N 260-73N57386Arair LLC · Kindred, NDBuilt 1973 · S/N 485-73N57390Beyer Mark E · Towanda, KSBuilt 1973 · S/N 83-73N57394Mccombs Evan · Peyton, COBuilt 1973 · S/N 84-73N57395Zangs William J · Poplar Grove, ILBuilt 1973 · S/N 488-73N57399Aerobatic 8kcab Holdings LLC · Murchison, TXS/N 85-73N57401Adams Kenneth · Marana, AZBuilt 1973 · S/N 376-73N57404Cp Aviation Inc · Santa Paula, CABuilt 1973 · S/N 940-73N57405Shoaf Douglas G · Lake Oswego, ORS/N 371-73N57407Britt Elaine L · Locust Grove, GABuilt 1973 · S/N 259-73N57408Phillips Thomas G · Fairbanks, AKBuilt 1973 · S/N 494-73N57410Eddy William Crawford III · Sugar Hill, GABuilt 1973 · S/N 941-73N57411Gregory Larry C Trustee · Farmington, MOBuilt 1973 · S/N 372-73N57412North County Flight Training Inc · Carlsbad, CABuilt 1973 · S/N 495-73N57420Florida Man Aviation LLC · Saint Petersburg, FLBuilt 1973 · S/N 942-73N57421Snider Roger A · Harlem, MTBuilt 1973 · S/N 498-73N57423Pardue Roy S · Clifton, VABuilt 1973 · S/N 92-73N57424Wood Flying Inc · Panhandle, TXBuilt 1973 · S/N 499-73N57428Zygomalas Stefanos · San Francisco, CABuilt 1973 · S/N 370-73N57430Swanson Michael D · Council Bluffs, IABuilt 1973 · S/N 944-73N57433Propwash LLC · Princeville, ILBuilt 1973 · S/N 88-73N57435Morkassel Gerald N · Waverly, OHBuilt 1973 · S/N 374-73N57440Frankel Daniel A · Madison, OHBuilt 1973 · S/N 946-73
Back to AD 2000-25-02 R1