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.

N4352EJohnson Gary I · Minot, NDS/N 7DC-13N4353CKeran Gary R · Natchitoches, LABuilt 1955 · S/N 7EC-372N4354CDavis Isaac J · Soldotna, AKS/N 7EC-373N4355CHaynes William S · Chillicothe, TXBuilt 1955 · S/N 7EC-374N4357CWarren Mark A · Colorado City, COBuilt 1955 · S/N 7EC-376N4357ESmith William H · Moultrie, GABuilt 1948 · S/N 7DC-18N4360EAnderson John E · Shell, WYS/N 7DC-21N4361CBogan Jimmy III · Denison, TXS/N 7EC-384N4362EFloura David P · Blackduck, MNBuilt 1948 · S/N 7DC-23N4363CHusmann Mark D · Delta, COBuilt 1956 · S/N 7EC-386N4364ELangley Aaron · Auburn, CABuilt 1948 · S/N 25N4365CPeters Patrick J · Wasilla, AKBuilt 1956 · S/N 7EC-388N4369CObrien James J III · Moreno Valley, CABuilt 1956 · S/N 7EC-393N4369EDatema Michael A · Jackson, CABuilt 1948 · S/N 11CC-195N436ACKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 2000 · S/N 411-2000N4370CPhillips Nickolas Hunter · Mikana, WIBuilt 1956 · S/N 7EC-394N4371CMayhew James · Greenfield, INS/N 7EC-395N4372CLussier John A · Greene, RIS/N 7EC-396N4373CSchallip Robert G Jr · Barbeau, MIBuilt 1956 · S/N 7EC-397N4373ETomczak Darrie-Jo L · So Int'L Falls, MNBuilt 1948 · S/N 7DC-32N4374CAir-O-Drome Aviation LLC · Caldwell, IDBuilt 1956 · S/N 7EC-398N4375CStone Philip R · East Syracuse, NYBuilt 1956 · S/N 7EC-399N4375EN4375e LLC · Erie, COBuilt 1948 · S/N 7DC-35N4377CThrash Howard G II · Lubbock, TXBuilt 1956 · S/N 7EC-401N4377EJeffryes Richard B · Creswell, ORBuilt 1948 · S/N 11CC197N4378EJim Petik And Sons · Keldron, SDBuilt 1948 · S/N 11CC-198N4379EMiller Andy D · Marana, AZBuilt 1948 · S/N 11CC-199N437ACHaggerty Kevin B · Bozeman, MTBuilt 1998 · S/N 393-98N4382CBouchard Ron · Lambert, MTBuilt 1956 · S/N 7EC-408N4383CCummings Nancie Jean · Miami, FLBuilt 1956 · S/N 7EC-409N4383ETuvman Kenneth B · Excelsior, MNS/N 11CC-200N4387CPearlman Aircraft Company · Orlando, FLBuilt 1956 · S/N 7EC-416N4388EN4388e LLC · Carthage, NCBuilt 1948 · S/N 11CC204N438ACHickerson Timmy D · Greenfield, INBuilt 2000 · S/N 438-2000N4390CBloom Jonah M · Palmer, AKS/N 7EC-419N4392CGrant Jacob A · Fairbanks, AKBuilt 1956 · S/N 7EC-421N4393CMitchell Lauren · Pacific Grove, CABuilt 1956 · S/N 422N4394CSchoney Brannon G · Spokane, WABuilt 1956 · S/N 7EC-423N4396EBudziszewski Mike S · Strandquist, MNBuilt 1948 · S/N 7DC-51N4397CChamp Pilots LLC · Forsyth, GABuilt 1956 · S/N 7EC-426N4397ELesh Greg A · Atwood, COBuilt 1948 · S/N 7DC52N4398CSnake Bit Aviation LLC · Pelham, GABuilt 1956 · S/N 7EC-427N4399CDunbar Clayton J · Bakersfield, CABuilt 1956 · S/N 7EC-428N439ACCompton Dwayne H · Jennings, LABuilt 1999 · S/N 424-99N439MASpotto Michael A · Palmer, AKBuilt 2002 · S/N 439-2002N43ACThomas Air Service Inc · Hastings, NEBuilt 1991 · S/N 645-91N43BPMichael W Miller LLC · Wilmington, DES/N 782-96N43EAVisionary Holdings LLC · Missoula, MTBuilt 2026 · S/N 1230-2026N43GBHenze Stacy A · Longmont, COS/N 769-96N43MTEcho Tango LLC · Greensboro, NCBuilt 1997 · S/N 402-98
Back to AD 2000-25-02 R1