OpenAirDocs.org
AD 2004-21-08 R1

Registered aircraft · 511

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:2004-21-08-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:2004-21-08-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.

N1525DHeintz John F · Los Angeles, CABuilt 1952 · S/N 7747N1528DMcpartland Patrick · Herriman, UTBuilt 1952 · S/N 7750N1532DShipman Jared K · Bismarck, MOBuilt 1952 · S/N 7754N1533DZimmerman Luke G · Madison, ALBuilt 1952 · S/N 7755N1535DHorney Paul · Russellville, ARBuilt 1952 · S/N 7757N1538DAdams Richard J · Mesa, AZS/N 7760N1541DCentral Air Service Inc · Lewistown, MTBuilt 1952 · S/N 7763N1551DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 7773N1555DSmith Michael D · North Myrtle Beach, SCBuilt 1952 · S/N 7777N1558DBelden George B Trustee · Sonoma, CAS/N 7780N1559DDougherty Peter I · Orchard Park, NYBuilt 1952 · S/N 7781N1560DSasser Christopher G · Ammon, IDS/N 7782N1563DTramontano Jeffrey M · Prosper, TXBuilt 1952 · S/N 7785N1566DMilton William H · West Glenville, NYBuilt 1952 · S/N 7788N1567DQualitair LLC Trustee · MichelstadtBuilt 1952 · S/N 7789N1569DPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7791N1570DBoswell Kurt R · Renton, WABuilt 1952 · S/N 7792N1571DMilton William H · West Glenville, NYBuilt 1952 · S/N 7793N1574DWilliams Marc A · Ridgecrest, CABuilt 1952 · S/N 7796N1576DMock Lurita M · Anderson, INBuilt 1952 · S/N 7798N1577DWilson Travis · Oswego, KSS/N 7799N1581DChippewa Aero LLC · Montevideo, MNBuilt 1952 · S/N 7864N1586DZucchero David M · Stanwood, WABuilt 1952 · S/N 7869N1591DBrewer George F II · Colorado Springs, COBuilt 1952 · S/N 7874N166VNLower Columbia River Company LLC · Longview, WABuilt 1950 · S/N 7588N174LAltitudes Aircraft Group LLC · Tampa, FLBuilt 1950 · S/N 7539N177URegistration Pending · Midvale, UTRegistration pendingBuilt 1949 · S/N 7433N177WAnderson David R · Sycamore, ILBuilt 1950 · S/N 7642N189PSchwartz Stephen R · Goldthwaite, TXBuilt 1950 · S/N 7488N1904UAircraft Partner Holdings Inc Trustee · BerlinBuilt 1950 · S/N 7592N190DFFuller Darel C · Moses Lake, WABuilt 1952 · S/N 7786N190ECMiller Dennis G · Galena, ILBuilt 1951 · S/N 7653N190LSSkinner Lawrence W · Fort Myers, FLBuilt 1950 · S/N 7542N190SMelichar Lynn R · Fort Lauderdale, FLS/N 7567N190VTMarshall Rodney E · Roscoe, ILBuilt 1948 · S/N 7171N1950CTupelo Aeronautics Inc · Tupelo, MSBuilt 1954 · S/N 16183N195ABYeoman David D · Bettendorf, IABuilt 1952 · S/N 7794N195AFCarlsbad Raceway Corp · Hemet, CAS/N 7651N195AKLeamon Douglas H Trustee · Stockwell, INBuilt 1952 · S/N 7778N195APTupelo Aeronautics Inc · Tupelo, MSS/N 16106N195BAButterfly Aviation Inc · Goodland, KSBuilt 1953 · S/N 16069N195BBWimbrow Henry J · West Redding, CTBuilt 1947 · S/N 7074N195BLTower Addison P · Grayslake, ILBuilt 1951 · S/N 7672N195BSSlatter Lowell J · Buhl, IDBuilt 1953 · S/N 16021N195BTPerlman Nathaniel H · Kirkland, WABuilt 1955 · S/N 16176N195BVAir Logistics Group LLC · Winston Salem, NCBuilt 1953 · S/N 16057N195CCMcguire Michael D · Lake Stevens, WABuilt 1953 · S/N 16093N195CGLake City Aero Ltd LLC · Grenada, MSBuilt 1953 · S/N 16120N195CKFischer James E · Lakeville, MNS/N 7515N195CNNoslen Enterprises · Goodland, KSBuilt 1954 · S/N 16163
Back to AD 2004-21-08 R1