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.

N81925Smith Gordon J · Manhattan, KSBuilt 1946 · S/N 7AC-550N81927Elliott Joel C · Pacoima, CABuilt 1946 · S/N 7AC-552N81928Lingwall John C · Peyton, COBuilt 1946 · S/N 7AC-553N81930Jones Victor A A · Delaware, OKS/N 7AC-555N81933Kendall James W · Sherwood, ORBuilt 1946 · S/N 7AC-558N81935Lambkin John C · Grand Rapids, MIBuilt 1946 · S/N 7AC-560N81939Johnson David H · Jasper, GABuilt 1946 · S/N 7AC-564N81945Goodenow William J · Kershaw, SCBuilt 1946 · S/N 7AC570N81946Potter Charles W · Clover, SCBuilt 1946 · S/N 7AC-571N81948Senseney Michael B · Kathleen, GABuilt 1946 · S/N 7AC-573N8194XCanale Michael D · Lake George, NYBuilt 1947 · S/N 11BC-69N81966Payne Robert · Lewiston, IDBuilt 1946 · S/N 7AC-591N81967Miller Shane A · Edgemont, SDBuilt 1946 · S/N 7AC-592N81971Holmgren David J · Plainfield, NJFirst renewal noticeBuilt 1946 · S/N 7AC-4399N81975Krejchik Daniel J · Portage, WIBuilt 1946 · S/N 7AC-600N81979Sabella Jacob · Wentzville, MOS/N 7AC-604N81983Peet James L · Valley Springs, CABuilt 1946 · S/N 7AC-608N81985Dewinter James A · Ludlow Falls, OHBuilt 1946 · S/N 7AC-610N81986Sullivan Daniel S · Fayetteville, GABuilt 1946 · S/N 7AC-611N81989Olvera Jose Carlos Trejo · Belton, SCBuilt 1946 · S/N 7AC-614N81990Hunter Green LLC · Helena, MTS/N 7AC-615N81BDGrondin Chris · Danforth, MEBuilt 1946 · S/N 7AC-6569N81BHPalmer Robert E · Cedar Key, FLBuilt 2011 · S/N 542-2011N81JHSmith William D · San Antonio, TXBuilt 1945 · S/N 7AC-57N81SDBurgess Jaret F · Fort Worth, TXS/N 922-2003N81SMSchwartz Grantham L · Garden City, TXBuilt 2005 · S/N 1402-2005N82003Bugsmashers Inc · San Miguel, CABuilt 1946 · S/N 7AC-628N82007Caldwell George A · Fairhope, ALBuilt 1946 · S/N 7AC-632N82012Thomson Mary Ellen · East Berlin, PABuilt 1946 · S/N 7AC-637N82014Mendenhall Lauri P · Ann Arbor, MIBuilt 1946 · S/N 7AC-640N82015Craig John S Jr · Glenburn, MEBuilt 1946 · S/N 7AC-641N82020Swyers Stinson R Jr · Ottsville, PABuilt 1946 · S/N 7AC-646N82027Stirk Michael T · Albion, NYBuilt 1946 · S/N 7AC-653N82029Sarason Jay A · Monte Vista, COBuilt 1946 · S/N 7AC-655N82038Peder Alexander E · Kirkland, WAS/N 7AC-664N82040Shamburg Daniel John · Tekamah, NEBuilt 1946 · S/N 7AC-666N82042Neubauer Michael A · Port Angeles, WABuilt 1946 · S/N 7AC-668N82043Billing Eric C · Nampa, IDBuilt 1946 · S/N 7AC-669N82050Scheiner Brett S · Newberg, ORBuilt 1946 · S/N 7AC-676N82052Medlin Kenneth O · Raleigh, NCBuilt 1946 · S/N 7AC-678N82059Studer Rod J · Shelby, MIBuilt 1946 · S/N 7AC-685N82061Krynik Mitchell G · Granbury, TXBuilt 1946 · S/N 7AC-687N82062Huffman Jacob M III · Burleson, TXBuilt 1946 · S/N 7AC-688N82068Schmalzried Joseph W · Darlington, PABuilt 1946 · S/N 7AC694N82069Geipel William R · Woodville, WIBuilt 1946 · S/N 7AC695N82070Hall Larry D · Conesus, NYBuilt 1946 · S/N 7AC-696N82072Thorne John S · Woodland Hills, CABuilt 1946 · S/N 7AC-698N82074Audo Michael J · Gobles, MIBuilt 1946 · S/N 7AC-700N82080Klomparens Zachary R · Lawton, MIBuilt 1946 · S/N 7AC-706N82088Stegeman Tim · South Haven, MIS/N 7AC-714
Back to AD 2000-25-02 R1