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.

N922TJBowar Gary R · Miranda, SDBuilt 2008 · S/N 503-2008N922WSWerth Jill · Canandaigua, NYBuilt 1973 · S/N 947-73N9232EHughes Justin L · Cedar Hill, TNBuilt 1946 · S/N 11AC-866N9239EMasephol Todd M · Athens, WIBuilt 1946 · S/N 11AC-873N923SQSprecher Susan E · Locust Grove, GAS/N 86-73N9242ERegistration Pending · Milton, FLRegistration pendingBuilt 1946 · S/N 11AC-876N9243ERegistered aircraftAssigned, pending cancellationS/N 11AC-877N9244EFrost Beverly J · Greenfield, INBuilt 1946 · S/N 11AC878N9245EJensen Jeffrey S · Alliance, NEBuilt 1946 · S/N 11AC-879N9246EPolhemus Christopher C · Carmichaels, PABuilt 1946 · S/N 11AC880N924JWStephenson James M Jr · Hyampom, CABuilt 2000 · S/N 860-2000N9252EHartzler Richard B · Grandview, MOBuilt 1946 · S/N 11AC-886N9255ERule Paul C · Wapato, WABuilt 1946 · S/N 11AC-889N9258VTomczak Christopher · Intl Falls, MNBuilt 1945 · S/N 7AC449N925ERCrosswell Joe D · Springtown, TXS/N 385-72N9260EStruck Larry G · Gardnerville, NVFirst renewal noticeBuilt 1946 · S/N 11AC-895N9261EMcvay Frank A · Bonaire, GABuilt 1946 · S/N 11AC-896N9262ESilvers Jason A · Chilhowee, MOBuilt 1946 · S/N 11AC-897N9263EWojdac David E · Mosinee, WIS/N 11AC-898N9264ENewcombe Emily S · Cascade, IDS/N 11AC-899N9265EMikesell Clifford W · Rochester, INBuilt 1946 · S/N 11AC-900N9267EErb Charles Allen · Holden, MEBuilt 1946 · S/N 11AC-902N9268EPancake C William Jr · Keyser, WVS/N 11AC-871N926BWTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1974 · S/N 770-74N926JPJl Aviation LLC · Crestwood, KYBuilt 2004 · S/N 490-2004N9271EHargrove Dwayne E · Shepherdsville, KYS/N 11AC906N9276EGriebsch James J · Saranac Lake, NYBuilt 1946 · S/N 11AC-914N9278EMurray Richard H · Celina, OHS/N 11AC-916N9279EHood Paul A · Saint Johns, MIBuilt 1946 · S/N 11AC-917N927SANpg Group LLC · Missoula, MTBuilt 2003 · S/N 927-2003N927WTHaugen Delos L · Burlington, NDBuilt 1966 · S/N 438N9283EErickson James R · State College, PABuilt 1946 · S/N 11AC-920N9284EDexter Fred H · Live Oak, FLBuilt 1946 · S/N 11AC-921N9287DWilson Robin W Trustee · Fairbanks, AKS/N 11AC-924N9288EMurray Richard H · Celina, OHBuilt 1946 · S/N 11AC-925N9290EMentgen William P · Greencastle, INBuilt 1946 · S/N 11AC-927N9291ECadotte Anthony John · Minnetonka, MNS/N 11AC-928N9293EMerrill Steven W · Proctor, MNBuilt 1946 · S/N 11AC-932N929ACWitman Michael R · Milliken, COS/N 20N929ELPatterson Bryan J · Brooks, GABuilt 1999 · S/N 828-99N929FMParker Johnny W · Murray, KYBuilt 1957 · S/N 7FC-5N92GKRatchford Herman Jr · Bessemer City, NCBuilt 2025 · S/N 1222-2025N92KBRaphael Dennis C · Colorado Springs, COBuilt 1992 · S/N 662-92N92SGStraight And Level LLC · Woodbine, MDBuilt 2014 · S/N 1149-2014N9300ECoy Shane A · Nenana, AKBuilt 1946 · S/N 11AC-938N9304ECarroll Charles · Ephrata, PABuilt 1946 · S/N 11AC-942N9305EWittmeyer Jody M · Dandridge, TNS/N 11AC-943N9307EChaudhary Rizvon · Louisville, KYS/N 11AC-944N9308EReynolds Richard E · Trumansburg, NYBuilt 1946 · S/N 11AC-946N9309EHenderson William R · Ohatchee, ALS/N 11AC-947
Back to AD 2000-25-02 R1