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.

N9339ASwede Aviation LLC · Tucson, AZS/N 7419N9341ARollison James · Scottsdale, AZS/N 7421N9346AWilliams Darrell W · Fayetteville, ARBuilt 1949 · S/N 7425N9348AShelomis Dennis B · Shelton, CTBuilt 1949 · S/N 7427N9350AGalloway Thomas E S · Oklahoma City, OKBuilt 1949 · S/N 7429N9353ARoelofs David M · Prescott, AZBuilt 1949 · S/N 7432N9359ABischof Timothy C · Saint Louis, MOS/N 7522N9362AFoster Floyd W · Lyon, MSBuilt 1950 · S/N 7523N9363AKincer Charles L · Richmond, MEBuilt 1949 · S/N 7442N9365AGuntly David A · Franksville, WIS/N 7444N9368AKimberlin Mark · Grants Pass, ORBuilt 1949 · S/N 7447N9370AKeltz Bennie J · Hillsdale, INBuilt 1949 · S/N 7449N9371ACosper Rodney S · Killeen, TXS/N 7450N9373AAlis Russell D · Fairbanks, AKBuilt 1949 · S/N 7452N9375AGillam Donald E · Lafayette, LABuilt 1949 · S/N 7454N9377AHawkins Bobby J · Greybull, WYBuilt 1949 · S/N 7456N9382ASeniw Alan G · Bonfield, ILBuilt 1949 · S/N 7461N9386AWarhank David · Rudyard, MTBuilt 1949 · S/N 7465N9387AMitchell Jeffrey S · Coldwater, OHBuilt 1949 · S/N 7466N9389AClark Christian Benjamin · Denver, COBuilt 1950 · S/N 7468N9395ARothacker Aviation LLC · Chester Springs, PABuilt 1950 · S/N 7474N9397ABarron Aviation LLC · Perry, MOBuilt 1950 · S/N 7555N9398ATraver Larry L · Sturgis, SDBuilt 1950 · S/N 7477N9399ABarron Aviation LLC · Perry, MOBuilt 1950 · S/N 7556N95UObrien Laurence J · Northridge, CABuilt 1951 · S/N 7714N96ACaldwell Mark K · Bunker Hill, INBuilt 1950 · S/N 7500N9800AB T Aircraft Restorations · Bellevue, WABuilt 1950 · S/N 7557N9801ASpivey Kenneth R Jr · Vestavia, ALBuilt 1950 · S/N 7480N9805AMay Richard U · Soquel, CABuilt 1950 · S/N 7484N9810ACarroll Judy Diane · Naples, FLBuilt 1950 · S/N 7489N9815AReese Steven A · Shoreline, WABuilt 1950 · S/N 7494N9823ADuke Kay L · Darrouzett, TXBuilt 1951 · S/N 7502N9826ADanek Brian C · Morris, ILBuilt 1950 · S/N 7505N9828AMitchell Thomas H · Kennewick, WABuilt 1950 · S/N 7507N9829ARoy Rodney E DBA · Grand Marais, MNS/N 7508N9833AKreit Kenneth Samuel · Catlett, VABuilt 1950 · S/N 7512N9835AMcclain Aviation LLC · Roanoke, TXBuilt 1950 · S/N 7528N9836AMabry Dale C · San Antonio, TXBuilt 1950 · S/N 7529N9847ASill Phillip II · New Castle, DEBuilt 1950 · S/N 7559N9848APearson Jeffrey W · Anaheim Hills, CABuilt 1950 · S/N 7541N9849AWatters James · Dwight, ILBuilt 1950 · S/N 7560N9851ARhoads Michael C · Ketchikan, AKS/N 7561N9854ASchlichar James C · Austin, TXBuilt 1952 · S/N 7547N9855AHawley Richard J · Moultonborough, NHBuilt 1950 · S/N 7548N9857ALarson Michael D · Erie, COBuilt 1949 · S/N 7550N9858AHolloway Donald P · Chino Hills, CABuilt 1950 · S/N 7551N9859ASchmidt Aaron B · Auburn, ALBuilt 1950 · S/N 7552N9863ACrowley John S Jr · Round Top, TXBuilt 1950 · S/N 7565N9866AKellum Mark J · Belden, MSBuilt 1950 · S/N 7568N9871ARegistered aircraftBuilt 1950 · S/N 7607
Back to AD 2004-21-08 R1