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.

N83849Polkar Norman A · Mount Orab, OHS/N 7AC-2530N83850Anderson Ordean · Gallatin Gateway, MTS/N 7AC-2531N83852Fields Joseph H · Placerville, CAS/N 7AC-2533N83854Sale Reported · Kansas City, MOSale reportedBuilt 1946 · S/N 7AC-2535N83856Hedgecock James Harvey · Kernersville, NCBuilt 1946 · S/N 7AC-2537N83861Picard Joerg · Grand Rapids, MIBuilt 1946 · S/N 7AC-2542N83862Depatie Jean-Francois · Albion, NYS/N 7AC2543N83871S&S Aviation LLC · Morse, LAS/N 7AC-2552N83877Walker Dale P · New Richmond, WIBuilt 1946 · S/N 7AC-2557N83879Veness Stephen E · Sabina, OHBuilt 1946 · S/N 7AC-2560N8387VN8387v LLC · Lansing, MIBuilt 1966 · S/N 507N83880Dotson Gary L · West Point, KYBuilt 1946 · S/N 7AC-2561N83881Morgan Charles R · Shelbyville, INBuilt 1946 · S/N 7AC-2562N83883Snell Gary A · Dresden, MEBuilt 1946 · S/N 7AC-2564N83886Lakeland Aero Club Inc · Lakeland, FLBuilt 1946 · S/N 7AC-2566N83891Gifford Scott A · Mcminnville, ORS/N 7AC-2572N83898Anderson Thomas M · Fairbanks, AKS/N 7AC-2579N83899Gilbert Kent G · Brookshire, TXBuilt 1946 · S/N 7AC-2580N8389VNelzen Wayne K · Mulino, ORBuilt 1966 · S/N 529N838BCN838bc LLC · Naperville, ILBuilt 2025 · S/N 1223-2025N83909Hobgood Mack H · Tylertown, MSBuilt 1946 · S/N 7AC-2591N8390VMapel Roger N · Weirton, WVBuilt 1966 · S/N 537N83911Warner John D · Covington, LABuilt 1946 · S/N 7AC-2594N83916Wharton Richard S · Amanda, OHBuilt 1946 · S/N 7AC2596N83918Barr Myron · Spanaway, WABuilt 1946 · S/N 7AC-2599N83919Harris Martin J · Ocklawaha, FLBuilt 1946 · S/N 7AC-2600N8391VRoflyco Ltd · Glendale, AZBuilt 1966 · S/N 107N83925D L S S Inc · Caro, MIS/N 7AC2608N83927Denormandie Jacob J · South Paris, MEBuilt 1946 · S/N 7AC-2610N83928Schaak William N · Billings, MTS/N 7AC-2611N83929Dasher George T · Culpeper, VABuilt 1946 · S/N 7AC-2613N83935Thorsen Clark L · Gordon, NEBuilt 1946 · S/N 7AC-2617N83936Adams James R · Prescott, AZBuilt 1946 · S/N 7AC-2618N83937Edwards David E · Mount Olive, NCBuilt 1946 · S/N 7AC-2619N83939Hammerle Tye F · Kenosha, WIBuilt 1946 · S/N 7AC-2621N83941Davis Gregory S · Hiawatha, KSBuilt 1946 · S/N 7AC-2623N83942Mcmullen Michael J · Lewistown, PABuilt 1946 · S/N 7AC-2624N83944Florida Aircraft Salvage Inc · Okeechobee, FLBuilt 1946 · S/N 7AC-2626N83945Sullivan Robert E · New York, NYBuilt 1946 · S/N 7AC-2627N83946Hall Larry D · Conesus, NYBuilt 1946 · S/N 7AC-2628N83948Dick James D II · Centerville, TNBuilt 1946 · S/N 7AC-2631N83957Poulter Thomas · Chelsea, MIBuilt 1946 · S/N 7AC-2643N83958Registration Pending · Palmerton, PARegistration pendingBuilt 1946 · S/N 7AC-2644N83959Am Flite Inc · Omaha, NEBuilt 1946 · S/N 7AC2645N8395VVandeman Jack A · Norco, CABuilt 1966 · S/N 530N83963Gray Shane Charles · Interlochen, MIBuilt 1946 · S/N 7AC-2649N83964Tesmer Air LLC · Libertyville, ILBuilt 1946 · S/N 7AC-2650N83967Harden Thomas H · Augusta, GABuilt 1946 · S/N 7AC-2653N83970Griffith Robert A · Prattville, ALBuilt 1946 · S/N 7AC-2656N83971Kepler Jason M · Wasilla, AKBuilt 1946 · S/N 7AC-2657
Back to AD 2000-25-02 R1