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.

N83703Rensberger Scott C · Lake Jackson, TXBuilt 1946 · S/N 7AC-2381N83710Ellis Chad A · Chrisman, ILBuilt 1946 · S/N 7AC-2388N83711Cameron Thomas J · Stanchfield, MNBuilt 1946 · S/N 7AC-2389N83715Middlebrook Paul E · Penn Yan, NYBuilt 1946 · S/N 7AC-2393N83716Florczyk Raymond S II · Clay, NYBuilt 1946 · S/N 7AC-2394N83719Makely Abraham M · Culpeper, VABuilt 1946 · S/N 7AC-2397N8371VPrairie Thermals LLC · Brookings, SDBuilt 1966 · S/N 82N83720Elliott Ryan A · Gallipolis, OHBuilt 1946 · S/N 7AC-2398N83725Tubbs Allan R · Greenvlle Jct, MEBuilt 1946 · S/N 7AC-2403N83729Haldeman Richard R · Mt Juliet, TNBuilt 1946 · S/N 7AC-2407N8372VVarwig Korrey L · Peoria, ILBuilt 1966 · S/N 432N83732Steenblik Jan W · Bloomington, INBuilt 1946 · S/N 7AC-2410N83733Nohlquist James L · Rochester, NYBuilt 1946 · S/N 7AC-2411N83735Mason Thomas M · Meredith, NHS/N 7DC-2413N83739Ala Coast Vintage Biplanes LLC · Irvington, ALBuilt 1946 · S/N 7AC-2417N8373VSeidler Marlyn L · Underwood, NDBuilt 1966 · S/N 121N83746Alfredo Cordero · Mc Alpin, FLBuilt 1946 · S/N 7AC-2424N83748Hochstetler Jared W · Cheyenne, WYBuilt 1946 · S/N 7AC-2426N8374VDexter Fred M · Live Oak, FLS/N 449N83751Easy Street Aviation LLC · Braxton, MSS/N 7AC-2429N83756Longuski Francis J · Vassar, MIFirst renewal noticeBuilt 1946 · S/N 7AC-2434N83757Anderson Thomas C Jr · Toone, TNBuilt 1946 · S/N 7AC-2435N83758Jella Christopher R · Jefferson City, MOBuilt 1946 · S/N 7AC-2436N8375VCarll Elizabeth M · Chicago, ILBuilt 1966 · S/N 505N83760Registration Pending · Hattiesburg, MSRegistration pending, canceledBuilt 1946 · S/N 7AC-2438N8376VKirkeby Dean A · Clark, SDBuilt 1966 · S/N 80N83771Wenzel Harry A · Medford, ORFirst renewal noticeBuilt 1946 · S/N 7AC-2449N83773Wallace Christopher L · Albuquerque, NMBuilt 1946 · S/N 7AC-2450N83774Hansen Eric P · Arlington, WABuilt 1946 · S/N 7AC-2451N8377VWeber William A · Brodhead, WIBuilt 1966 · S/N 280N83780Hoffman Willam C · Rostraver Township, PAS/N 7AC-2458N8378VDollins Carl E · Grosse Ile, MIBuilt 1966 · S/N 486N83790Harlow Timothy P · Spring, TXS/N 7AC-2462N83791Van Farowe Gary A · Hudsonville, MIBuilt 1946 · S/N 7AC-2469N83792S Dacy Enterprises Inc · Harvard, ILBuilt 1946 · S/N 7AC2466N83797Felda Flyers LLC · Felda, FLBuilt 1946 · S/N 7AC-2475N83800Armstrong Robert A · Canby, ORBuilt 1946 · S/N 7AC-2478N83802Floren Donald D · Royal City, WABuilt 1946 · S/N 7AC-2480N83805Mazure Glenn J · Bad Axe, MIBuilt 1946 · S/N 7AC-2483N83806Sheaffer Douglas P · Narvon, PABuilt 1946 · S/N 7AC2484N8380VMaxwell Frank R · Fairbanks, AKBuilt 1966 · S/N 70N83812Casner Bruce W · Jeffersonton, VABuilt 1946 · S/N 7AC2492N83813Elbert County Air Force LLC · Elbert, COBuilt 1946 · S/N 7AC-2493N83822Christmann James C Trustee · Santa Cruz, CABuilt 1946 · S/N 7AC-2502N83823Thompson Chase M · Carthage, MOBuilt 1946 · S/N 7AC-2503N83824Talutis William R · Murchison, TXBuilt 1946 · S/N 7AC2504N83835Ltg Enterprises LLC · Fort Wayne, INBuilt 1946 · S/N 7AC-2516N83837Davenport Jimmy J · Hayesville, NCBuilt 1946 · S/N 7AC-2518N83838Morrison James J II · Grandview, TXBuilt 1946 · S/N 7AC-2519N83842Reeves Jeffrey A · Bothell, WABuilt 1946 · S/N 7AC-2523
Back to AD 2000-25-02 R1