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.

N41700Craven Mark C · Salome, AZBuilt 1973 · S/N 596-73N4170EHuntling Terry · Indio, CABuilt 1947 · S/N 11CC-72N4170YCraig Jerome A III · Plantation, FLBuilt 1977 · S/N 284-77N4172YColonels Flying Club · Princeton, MNBuilt 1976 · S/N 1186-77N4176EMacveigh Craig A · New Carlisle, OHS/N 11CC-78N4177A77 Aero Inc · Naples, FLBuilt 2021 · S/N 1480-2021N4178EWest Michigan Aviation Inc · Kalamazoo, MIBuilt 1947 · S/N 11CC-80N41797Valdes Eusebio · Miami, FLBuilt 1973 · S/N 117-73N41798Fried Dennis A · Selfridge, NDBuilt 1973 · S/N 515-73N4179EBell Scott A · Mc Alpin, FLBuilt 1947 · S/N 7BCM-174N417DMKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 417-99N417SPTonys Aerial Service Inc · Great Bend, KSBuilt 1980 · S/N 1350-80N41800Mccully Heather L · Payson, AZBuilt 1973 · S/N 981-73N41801Freeman James E · Dalworthington Gar, TXBuilt 1973 · S/N 605-74N41802Trs Holdings LLC · Kalispell, MTBuilt 1973 · S/N 402-73N41803Minot Aero Center · Minot, NDBuilt 1973 · S/N 598-73N41804Beulen Brian V · Mesa, AZFirst renewal noticeBuilt 1973 · S/N 279-73N41805Fosdick Kenneth E · Plymouth, MABuilt 1973 · S/N 982-73N41807Reid Robert W DBA · Independence, ORBuilt 1973 · S/N 403-73N41808Noble Raymond D · East Windsor, CTBuilt 1973 · S/N 558-73N41809Britten Ben K · North Pole, AKBuilt 1973 · S/N 602-73N4180EHesse Jeffry L · Talkeetna, AKS/N 11CC-81N41811Farm Air Inc · Astoria, ILBuilt 1973 · S/N 404-73N41813Secrest Kenneth W · Griffin, GABuilt 1973 · S/N 603-73N41816Privitt Bret J · Fort Worth, TXBuilt 1973 · S/N 405-74N41819Crop Jet Aviation LLC · Gooding, IDBuilt 1974 · S/N 1-74N4181EShooting Star Services LLC · Rosamond, CAS/N 11CC-82N4181YBruce A Morey · Wills Point, TXBuilt 1977 · S/N 1188-77N41820Wagner Patricia · West Milton, OHBuilt 1973 · S/N 985-74N41821Gilroy Joseph T · Escalon, CAS/N 1021-74N41822Kitchen Thomas M · Indiana, PABuilt 1973 · S/N 280-74N4182EJones Jacob R · Rockford, TNBuilt 1947 · S/N 11CC-83N4182YShouling & Philip Enterprise · Lancaster, CABuilt 1977 · S/N 604-77N4184YMoncrief Rick L · Melba, IDS/N 600-77N4185EHuffman Myron · Felda, FLS/N 11CC-86N4187YStohr Beuford G · Woden, IABuilt 1977 · S/N 289-77N4189EJamieson Robert F · Friday Harbor, WABuilt 1947 · S/N 11CC-89N4189YBaldacci Eric · Katy, TXBuilt 1977 · S/N 1191-77N4192YDragon Grass LLC · Nashua, NHS/N 966-77N4194YPyne James E · Tucson, AZS/N 602-77N4197YAgnew Michael D · Pardeeville, WIS/N 1193-77N4198YGallo Michael R · High Falls, NYBuilt 1977 · S/N 292-77N4199YPanhandle Consulting LLC · Dallas, GAS/N 1194-77N419ACSimmons Scott · Anchorage, AKBuilt 2000 · S/N 408-99N419DMNote Clayton R · Eagle Point, ORBuilt 2003 · S/N 442-2003N419DSLien Christian B · Rapid City, SDBuilt 2006 · S/N 1030-2006N419JRRaf LLC · Lenexa, KSBuilt 1995 · S/N 759-95N419SAStephens Kristi J · Bellingham, WABuilt 2003 · S/N 912-2003N41AGSkyline Agrinautics Inc · Osage, IABuilt 1996 · S/N 768-96N4200YTexas Red Bird LLC · Palo Pinto, TXBuilt 1977 · S/N 964-77
Back to AD 2000-25-02 R1