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.

N84113Palmatier Robert J · Orange Park, FLBuilt 1946 · S/N 7AC-2800N84115Stormer Isaac · Curtis, WAS/N 7AC-2802N84116Koliadko Joseph I · Luray, VABuilt 1946 · S/N 7AC-2804N84120Saylor Kasey · Searcy, ARS/N 7AC-2807N84121Myers Stanley A · Linn, MOBuilt 1946 · S/N 7AC-2808N84123Cahill Herbert G · Chesapeake, VABuilt 1946 · S/N 7AC-2810N84124Mussman Craig · Grant Park, ILS/N 7AC2811N84126Three J Flying LLC · West Des Moines, IABuilt 1946 · S/N 7AC-2815N84127Anderson Blake T · Locust Grove, GABuilt 1946 · S/N 7AC-2814N84139Bakrevski Lupcho · Valparaiso, INS/N 7AC2824N84144Grindeland Ethan P · Hatton, NDBuilt 1946 · S/N 7AC-2830N84149Bower Kevin R · Oldenburg, INBuilt 1946 · S/N 7AC-2833N84155Grissom Michael D Jr · Henderson, NCS/N 7AC-2844N84157Padisak Michael · Traverse City, MIS/N 7AC-2843N84158Rinaudo James J · Gulf Shores, ALBuilt 1946 · S/N 7AC-2845N84160Preston Robert J · Pittstown, NJBuilt 1946 · S/N 7AC-2847N8416388 Charlies Inc · Palmyra, WIBuilt 1946 · S/N 7AC-2849N84164Eisberg Keith W · Columbia, MOS/N 7AC-2851N84166Prather Carl Lynn · Gilroy, CABuilt 1946 · S/N 7AC-2853N84167Tate Edwin N · Sheridan, ORBuilt 1946 · S/N 7AC-2854N84168Bost Roger C · Greensboro, NCBuilt 1946 · S/N 7AC-2856N84171Gates Glen C · Lapeer, MIBuilt 1946 · S/N 7AC-2859N84177Zimmerman Steven W · Olathe, KSBuilt 1946 · S/N 7AC2865N84178Thompson Steve DBA · Pauls Valley, OKBuilt 1946 · S/N 7AC-2866N84181Purcell David S · Chandler, AZBuilt 1946 · S/N 7AC-2869N84184Waterman David N DBA · Amery, WIBuilt 1946 · S/N 7AC-2872N84192Burraston Richard D · Millcreek, UTBuilt 1946 · S/N 7AC-2880N84197Short Michael J · Independence, ORS/N 2885N84198Jack Jeremiah Russell · Napa, CABuilt 1946 · S/N 7AC-2886N84199Owen James G · Maynardville, TNBuilt 1946 · S/N 7AC2887N84203Harter Michael R · Greenfield, INS/N 7AC-2894N84206Sale Reported · West Richland, WASale reportedBuilt 1946 · S/N 7AC-2897N84215Hardy Randall B · Argyle, TXBuilt 1946 · S/N 7AC-2906N84218Feeney Francis Kevin · Spencer, NYBuilt 1946 · S/N 7AC-2909N84222Ornelaz Bernice R · San Jose, CABuilt 1946 · S/N 7AC-2913N84228Marshall Donald R · Cape Girardeau, MOBuilt 1946 · S/N 7AC-2919N84230Yuri Flyers LLC · Kalamazoo, MIBuilt 1946 · S/N 7AC-2922N84231Ptaschinski Charles O · Shawano, WIBuilt 1946 · S/N 7AC-2923N84232Koehler Steven W · New Braunfels, TXBuilt 1946 · S/N 7AC-2924N84238Simmons Rita B · Saint George, MEBuilt 1946 · S/N 7AC-2930N84241Kuhn Darrell G · Irma, WIBuilt 1946 · S/N 7AC-2933N84242Steck Paul D · Pelham, NHBuilt 1946 · S/N 7AC-2934N84244Campbell Stephen C · Millinocket, MEBuilt 1946 · S/N 7AC-2936N84246Light Flight Balloons Inc · Bel Air, MDBuilt 1946 · S/N 7AC-2938N84252Calk Mark C · Troy, ALBuilt 1946 · S/N 7AC-2944N84254Middleton Steven H · Monroe, NCBuilt 1946 · S/N 7AC-2946N84255Black James W · Kenly, NCS/N 7AC-2947N84261Holcomb Garry M · Point, TXBuilt 1946 · S/N 7AC-2953N84268Zvada Stephen P · Wadsworth, OHBuilt 1946 · S/N 7AC-2958N84269Super Cub Flyers Inc · Tower, MNBuilt 1946 · S/N 7AC-2963
Back to AD 2000-25-02 R1