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.

N43WJHughes Todd R · Rocky Ford, COBuilt 1972 · S/N 318-72N4408EStroup Stephen L · Atwater, OHBuilt 1948 · S/N 7AC-7186N440ACColeman Ben · Lakeland, FLBuilt 1997 · S/N 1364-97N4412EVotava Paul A · Mcintosh, MNBuilt 1948 · S/N 11CC-226N441ACAero Champ LLC · Orlando, FLS/N 401-97N44278Fredrickson Mark J · Chetek, WIBuilt 1958 · S/N 642N4427EJ P Aero Holdings Inc · Carson City, NVBuilt 1948 · S/N 7AC-7188N44288Foley Sumner R · Spring Hill, FLBuilt 1946 · S/N 7AC6746N4430ELabby Carolina S · Livermore, CABuilt 1948 · S/N 7AC-7191N4434EHines Thomas J · Amsterdam, NYBuilt 1948 · S/N 7DC-68N4435EWindjue Bryan · Jamestown, NDS/N 7DC-69N443ACSp Sun LLC · Half Moon Bay, CABuilt 2000 · S/N 442-2000N443ERivenbark Michael Keith · Clinton, NCS/N 102N443RLGuinn Timothy J · Jennings, LABuilt 1996 · S/N 1223-96N443WBHusted Dean T · Hicksville, OHBuilt 1945 · S/N 7AC-367N4440ENeeves Aviation And Flying LLC · Sioux Falls, SDBuilt 1948 · S/N 11CC-221N4446EGreer James E · Summit Point, WVBuilt 1948 · S/N 7CCM-103N444AWHangar 22 LLC · Wilmington, DEBuilt 1995 · S/N 373-95N444BLTri Air LLC · Monette, ARBuilt 1966 · S/N 99N444NXAce Aviation LLC · Mankato, MNBuilt 2000 · S/N 419-2000N444PFRegistered aircraftBuilt 1979 · S/N 543-79N4451EMock David H III · Burleson, TXS/N 7CCM-105N4452EZaragoza Justin A · Jacksonville, FLBuilt 1948 · S/N 7DC-84N4453EMbsp Enterprises Inc · Wilmington, DEBuilt 1948 · S/N 7DC-85N4453PHousel LLC DBA · Palm Harbor, FLS/N 11AC318N4459EFoley Martin L · Hadley, NYBuilt 1948 · S/N 7AC-7197N445ACTholen Susan M · Kennebunk, MEBuilt 1998 · S/N 389-98N4460EHarwood Mark D · Cossayuna, NYBuilt 1948 · S/N 7DC-87N4462EDagg Geoffrey · Wenatchee, WAS/N 7DC-88N446ACRegistered aircraftBuilt 2000 · S/N 446-2000N44748Fortman Melanie · Kalida, OHBuilt 1946 · S/N 7AC-5950N4479ETampa Bay Flying Club LLC · Palmetto, FLBuilt 1948 · S/N 7DC101N4481EChambers David N · Cullman, ALBuilt 1948 · S/N 7DC-103N4485EManly Dodson W · Fruitland Park, FLBuilt 1948 · S/N 7DC-105N4487ESmith Ronald D · Anderson, INBuilt 1948 · S/N 7DC-72N4489EScott Phillip E · Owensville, INS/N 7DC-107N448TWalton Equipment Co · Jonesboro, ARS/N 635-2023N4493EFnf Aviation LLC · Kalamazoo, MIBuilt 1948 · S/N 7DC-108N4498EMyers Joe A · Rush Springs, OKBuilt 1948 · S/N 7DC-116N44FCRadigan Laura L · Merritt Island, FLBuilt 1946 · S/N 7AC-2005N44HKBradt Joseph J · Inver Grove, MNBuilt 1997 · S/N 79597N44ZWTurner Robert H · San Diego, CABuilt 1977 · S/N 322-77N4504EHall Nathan M · Shepherd, MTBuilt 1948 · S/N 7DC-121N4507ETaylor John · Canaan, CTBuilt 1948 · S/N 7CCM-113N450ACDyer Michael E · Live Oak, FLS/N 7AC-5933N4510EScroggin Gregory K · Minnetrista, MNBuilt 1948 · S/N 11CC-235N4513EMigis James P · Shady Shores, TXBuilt 1948 · S/N 7DC-124N4514EThomas Kevin L · Presho, SDS/N 7DC-125N4515ELewis Charles D · Lincoln, NEBuilt 1948 · S/N 7DC-126N4516EHenderson Beverly A · Sharon Springs, KSS/N 7DC-127
Back to AD 2000-25-02 R1