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.

N1141EGuttormson Gene A · Georgetown, MNBuilt 1946 · S/N 7AC-4697N1142EHenderson Joseph C IV · Midlothian, VABuilt 1946 · S/N 7AC-4698N1143ENevarrow Leon · Spring Valley, CABuilt 1977 · S/N 1215-77N1143VDevine Patrick · Weldon Spring, MOBuilt 1956 · S/N 47970N1144EBuergel Sandra J · East Aurora, NYBuilt 1946 · S/N 7AC-4700N1146EMj Consulting Inc · Parsons, KSBuilt 1946 · S/N 7AC4702N1148EDb Airfreight Inc · Wake Forest, NCBuilt 1946 · S/N 7AC-4704N114JMC29 Taildragger LLC · Middleton, WIBuilt 2006 · S/N 481-2006N114TJKnochenmus Matthew L · Corcoran, MNBuilt 1996 · S/N 382-96N1151ELuke Stanley W Jr · Rochester Hills, MIS/N 7AC-4707N1152ELeeds Stained Glass Co Inc · Leeds, ALBuilt 1946 · S/N 7AC-4708N1154ENewberry Richard A Sr · Springdale, ARBuilt 1946 · S/N 7AC-4710N1155EN1155e LLC · Houma, LAS/N 311-77N1156EGooding Flying Club · Gooding, IDBuilt 1977 · S/N 986-77N1159ERegistration Pending · Sherwood, ORRegistration pending, canceledBuilt 1977 · S/N 312-77N115BYPobiega Michael J · Fort Mill, SCBuilt 2004 · S/N 488-2004N115SCMohamed Eman Z · Lubbock, TXBuilt 1946 · S/N 11 BC 602N115SGAileron Aviation LLC · Knoxville, TNBuilt 2001 · S/N 1316-2001N1160ESrt Aero · Pauls Valley, OKBuilt 1946 · S/N 7AC-4716N1161EViking Champ Club · Eleva, WIS/N 7AC-4717N1162EBailey Carlton D Jr · Huntington, WVBuilt 1946 · S/N 7AC-4718N1163EKnik Flying Club LLC · Anchorage, AKS/N 987-77N11642Alexander Andrew B · Anchorage, AKBuilt 1972 · S/N 836-72N11643Henderson George L · Fresno, CABuilt 1975 · S/N 549-75N11645Tango Bravo Air LLC · Nederland, COBuilt 1972 · S/N 344-72N11646Hough Howard A · Paris, TNBuilt 1972 · S/N 311-72N11647Ronsman Harry · Talkeetna, AKBuilt 1972 · S/N 345-72N1164DStreng Martin K · Carson City, NVBuilt 1972 · S/N 837-72N11650Dupuis Charles Jr · Breaux Bridge, LABuilt 1972 · S/N 839-72N11657Morgan Jacob R · Salem, INBuilt 1972 · S/N 347-72N11658Lorenz William D · Benson, MNBuilt 1972 · S/N 234-72N11659Villa Holdings LLC · Commerce, CABuilt 1972 · S/N 304-72N1165ETruman Sparks Aviation LLC · Wink, TXBuilt 1977 · S/N 1216-77N11660Gottschalk Brian D · Moscow, IDS/N 305-72N11663Parisi Keith P · Wallkill, NYBuilt 1972 · S/N 842-72N11664Mosher Jacob D · Nevada, MOBuilt 1972 · S/N 843-72N11667Winiarski Kenneth J · Forest Twp, MEBuilt 1972 · S/N 845-72N11668Cummings Arthur J · Delta Junction, AKS/N 349-72N1166ELake Jeffrey W · Steamboat Springs, COBuilt 1977 · S/N 251-77N11670Michaud Paul K · Forest Lake, MNBuilt 1972 · S/N 846-72N11672Mooney Services LLC · Greenbush, MNS/N 848-72N11673Clobes Warren J · Evansville, WIBuilt 1972 · S/N 356-72N11675Nilles Paul · Athens, OHBuilt 1972 · S/N 850-72N11676Stone Air LLC · Carrollton, GABuilt 1972 · S/N 236-72N11677Irby Darrell · Keller, TXBuilt 1972 · S/N 306-72N11679King Nathan A · Dunkirk, MDBuilt 1972 · S/N 307-72N1167EGabbert Tate · Sarasota, FLBuilt 1946 · S/N 7AC-4723N11680Adams Jonathan · Columbia, MOBuilt 1972 · S/N 21-72N11681Amelia Reid Aviation LLC · San Jose, CABuilt 1972 · S/N 308-72N11683Osborne Barry G · Brainerd, MNBuilt 1972 · S/N 852-72
Back to AD 2000-25-02 R1