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.

N3035BFlying W Aviation Enterprises · Bellevue, NEBuilt 1952 · S/N 7918N3037BQualitair LLC Trustee · MichelstadtBuilt 1952 · S/N 7920N3042BDiaz Carlos Ricardo · Pensacola, FLBuilt 1952 · S/N 7925N3045BSmokovitz Joseph M · Tecumseh, MIBuilt 1994 · S/N 7928N3050BNelson William W · Saint Petersburg, FLBuilt 1952 · S/N 7933N3056BO'Brien Alan S · Camarillo, CABuilt 1952 · S/N 7939N3057BRobins Jack S · Kaysville, UTBuilt 1952 · S/N 7940N3058BUpper Limit LLC · Big Lake, AKBuilt 1952 · S/N 7941N3064BSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1955 · S/N 7947N3067BImwalle John N · Batavia, OHBuilt 1952 · S/N 7951N3069BRampersad Carlyle · Wilmington, DEBuilt 1952 · S/N 7953N3070BBriscoe Joseph C · Gresham, ORBuilt 1952 · S/N 7954N3071BSwing Shift Aviation LLC · Wilmington, DEBuilt 1952 · S/N 7955N3074BBohl Howard M · Temecula, CABuilt 1952 · S/N 7958N3081BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7966N3083BBachmann Michael · York, SCBuilt 1952 · S/N 7968N3085BBrown Daniel A · Gettysburg, PABuilt 1952 · S/N 7970N3087BBlilie Dennis L · Walcott, NDS/N 7972N3089BSeibert Mark R · Monticello, MNBuilt 1952 · S/N 7974N3090BGreen & Green Construction Co Of Grenada Inc · Grenada, MSS/N 7975N3091BRadisch Herbert R Jr · San Diego, CABuilt 1952 · S/N 7976N3098BKirsteatter Todd Paul · Kewaunee, WIBuilt 1952 · S/N 7983N3099BStallings James K · Alva, OKBuilt 1953 · S/N 7984N3170GHolbrook Maslen · Caldwell, IDS/N 7590N33VRegistration Pending · Colfax, ILRegistration pendingBuilt 1948 · S/N 7240N3401RBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7395N3426VNikolaus Larry · Huntington, WVBuilt 1948 · S/N 7111N3427VHowker John A · Louisville, KYBuilt 1948 · S/N 7128N3435VChieffo Robert · Poughquag, NYBuilt 1948 · S/N 7120N3440VBarrientos Jeri D · Collinsville, OKBuilt 1948 · S/N 7144N3442VAdams Richard J · Mesa, AZBuilt 1948 · S/N 7146N3443VMenard Charles H · Burton, MIBuilt 1948 · S/N 7133N3446VPlane Fun Inc Tr Trustee · Snellville, GAS/N 7136N3450VSchreiner Michael · Dallas, TXBuilt 1948 · S/N 7147N3451VPearman Aubum D · Tupelo, MSS/N 7148N3457VSchwab Coyle P · St Charles, ILBuilt 1948 · S/N 7154N3458VEastern Stearman Inc Trustee · Leesburg, VAS/N 7159N3462VSiefring Sean E · Collierville, TNBuilt 1948 · S/N 7187N3465VLiebfried Andrew · Lunenburg, MABuilt 1948 · S/N 7162N3474VWestern North Carolina Air Museum · Hendersonville, NCBuilt 1948 · S/N 7174N3482VBorden Leon D · Arcadia, CAS/N 7182N3484VWeiss Elliott · Fresno, TXS/N 7184N3485VMyron Alexander Tedrow · Morristown, TNBuilt 1948 · S/N 7211N3488VCurrier Susan · Greenvlle Jct, MEBuilt 1948 · S/N 7192N3491VKalbermatter Guillermo A · Ventura, CABuilt 1948 · S/N 7195N3493VWhalen John M III · Boise, IDS/N 7197N3499VSponsler William D · St Charles, ILBuilt 1948 · S/N 7203N34PScootair LLC · Alburgh, VTS/N 7193N355STScootair LLC · Alburgh, VTBuilt 1948 · S/N 7285N369JJB&B Aviation LLC · Evansville, INBuilt 1950 · S/N 7510
Back to AD 2004-21-08 R1