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.

N82093Oborny Alan R · Choteau, MTBuilt 1946 · S/N 7AC-719N82095Hirschel Arthur D · Eureka, SDBuilt 1946 · S/N 7AC-721N82098Arbaugh Joanne N · Harbor Springs, MIBuilt 1946 · S/N 7AC-724N82099Henricks Terry E · Archbold, OHBuilt 1946 · S/N 7AC-725N820SDBachman Ryan · Mesa, AZFirst renewal noticeBuilt 1998 · S/N 820-98N82101Sutherland Johnny Leon · Goldthwaite, TXBuilt 1946 · S/N 7AC-727N82103Petro Jerry R · Williamsburg, VABuilt 1946 · S/N 7AC-729N82104Caulkins Howell V · Chico, CABuilt 1946 · S/N 7AC-730N82105Ennis Michael J · Eminence, MOBuilt 1946 · S/N 7AC-731N82106Morrison Lillian M · Port Townsend, WABuilt 1946 · S/N 7AC-732N82107Mclavy Michael J · Puyallup, WABuilt 1946 · S/N 7AC-733N82113Strain D Bret · White River, SDBuilt 1946 · S/N 7AC-739N82117Johnson Scott E · Union Bridge, MDBuilt 1946 · S/N 7AC-743N82125J & D Services Inc · Wilmington, DEBuilt 1946 · S/N 7AC-751N82129Gruhlkey Cameron T · Dalhart, TXBuilt 1946 · S/N 7AC-755N82134El Paso Flying Service LLC · El Paso, ILBuilt 1946 · S/N 7AC-760N82135Willis Roger · Belleview, FLBuilt 1946 · S/N 7AC-761N82137Abbott Dylan L · Lompoc, CABuilt 1946 · S/N 7AC-763N82138Abrahamson Duane E · Manawa, WIBuilt 1946 · S/N 7AC-764N82140Bingham Sammy J · Manvel, TXBuilt 1946 · S/N 7AC-766N82142Snell Gary A · Dresden, MEBuilt 1946 · S/N 7AC-768N82146Sale Reported · Williamson, NYSale reportedBuilt 1946 · S/N 7AC-772N82147Sipes Robert L · Mound City, MOBuilt 1946 · S/N 7AC-773N82150Houghton Robert E · North Ferrisburgh, VTBuilt 1946 · S/N 776N82151Gramke Thomas · Tekamah, NES/N 7AC-777N82153Catlin Vaughn H · Mardela Springs, MDS/N 7AC-779N82154Hutter Charles G · Carson City, NVBuilt 1946 · S/N 7AC-780N82158Noble Wendell · Nicholasville, KYBuilt 1946 · S/N 7AC-784N82159Morris Larry R · Guntersville, ALBuilt 1946 · S/N 7AC-785N82160Coop David L · Albia, IABuilt 1946 · S/N 7AC-786N82170Colombe George L · Wentworth, SDBuilt 1946 · S/N 7AC-796N82179Sibbitt Alice N · Chandler, AZBuilt 1946 · S/N 7AC-806N82181Hester James T · Fayetteville, GABuilt 1946 · S/N 7AC-809N82183Westland Mark Eric · Saint George, UTBuilt 1946 · S/N 7AC-810N82184N82184 LLC · Indianapolis, INS/N 7AC-811N82187Dolder Gary E · Waterman, ILBuilt 1946 · S/N 7AC-814N82199Syverson Michael B · Waubun, MNBuilt 1946 · S/N 7AC-827N82200Markwood Hannah E · Anchorage, AKS/N 7AC828N82201Mgs Ventures Ltd · Wilmington, DES/N 7AC-829N82202Air-K Enterprises LLC · Weirsdale, FLBuilt 1946 · S/N 7AC-830N82205Mcinerny Charles H Jr · Dansville, NYBuilt 1946 · S/N 7AC-833N82206Braswell Randall A · Wisner, LABuilt 1946 · S/N 7AC-834N82215Robinson Michael F · Decatur, ALBuilt 1946 · S/N 7AC-843N82219Myakka Head Aviation LLC DBA · Bradenton, FLS/N 7AC-847N82220Snyder Jason D DBA · Oakland, MDBuilt 1946 · S/N 7AC-848N82230Grieser James K · Wauseon, OHBuilt 1946 · S/N 7AC-858N82234Long Kenneth L · Everett, WABuilt 1946 · S/N 7AC-862N82235Begley Scott R · Fairbanks, AKS/N 7AC-863N82244Burgess Edward P · Elizabethtown, KYBuilt 1946 · S/N 7AC-872N82245Prather Carl L · Gilroy, CABuilt 1946 · S/N 7AC-873
Back to AD 2000-25-02 R1