AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N4338PTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1984 · S/N 28-8490050N4338QRegistration Pending · Salisbury, NCRegistration pendingBuilt 1971 · S/N 17260238N4338RThompson Group Inc · Stockton, CABuilt 1974 · S/N 17263091N4338TBenham Properties LLC · Sullivan, INS/N 28-7205144N4338VFlying Mermaid LLC · Aiea, HIBuilt 1984 · S/N 28-8490052N4338ZJwg Aviation LLC · Livingston, MTBuilt 1968 · S/N 18-8656N43394Skyline Solutions Inc · Deland, FLS/N 34-7450186N4339DSterk Ashton D · Lees Summit, MOBuilt 1992 · S/N 2391N4339HKaufman Timothy H Trustee · Saint Charles, MIBuilt 1978 · S/N 24-0711N4339MLazor Ronald E · Middlefield, CTBuilt 1947 · S/N 12-3275N4339QC & K Aero LLC · La Valle, WIBuilt 1971 · S/N 17260239N4339RBurke Brian · Westlake, OHBuilt 1974 · S/N 17263092N433AGRinehart Orville J · Forest Lake, MNBuilt 1978 · S/N AA5A0589N433CBTeam Cb LLC · Missoula, MTBuilt 2022 · S/N 3402N433DPPitzer Douglas A · Corona, CABuilt 2003 · S/N MK-0433N433FLTrue North Aviation LLC · Cooperstown, NDBuilt 1971 · S/N 28-7125217N433FRKtoa Rentals LLC · Torrance, CABuilt 1997 · S/N 17280292N433FSPontoni Michael E · Newnan, GABuilt 1997 · S/N 3306N433JDRittenhouse John D · Costa Mesa, CABuilt 2005 · S/N 90321N433MASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 28-43362N433PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496063N433PCRoush Russel A Trustee · Gillette, WYBuilt 1956 · S/N 18-4874N433PTPilot Training Center LLC · Miami, FLBuilt 1974 · S/N 17263088N433RAHudson Allen D · Rio Grande, OHS/N 28-22705N433RMRocky Mountain College · Billings, MTBuilt 1974 · S/N 17262914N433TJKennedy John A · Marietta, GABuilt 1992 · S/N 661-92N433VBPalumbo Christopher · San Antonio, TXBuilt 1974 · S/N BH120/222N433WKingdom Air Corps · Sutton, AKBuilt 1953 · S/N 25962N433WWFleming Judith A · Murrieta, CABuilt 2000 · S/N 5156N43408Miloud Chadd K · Fort Worth, TXBuilt 1984 · S/N 28-8416048N4340HEiden Ryan J · Central, AKS/N 15-125N4340MMiller William M · Brenham, TXBuilt 1947 · S/N 12-3276N4340ZBrown Helicopter Inc · Pensacola, FLBuilt 1968 · S/N 18-8658N43419Grogan II Jerrald V · Prairie City, IABuilt 1993 · S/N 0110N4341HGunstream Jesse B III · League City, TXBuilt 1978 · S/N 24-0712N4341JSundstrom Steven · Reno, NVBuilt 1998 · S/N 22973N4341PToribio LLC · San Antonio, TXS/N PJ0222366N4341ROleary Paul V · Gold Creek, MTBuilt 1974 · S/N 17263094N4341TSmith Theodore D · Palm Bay, FLBuilt 1998 · S/N 22231N4341WBarlow Steven J · Mansfield, OHBuilt 1974 · S/N MC-270N4341ZMeans Loren Alonzo III · Wasilla, AKBuilt 1968 · S/N 18-8659N43422Weaver Erik J · Roseburg, ORBuilt 1974 · S/N 28-7415487N4342CTwin City Air Activities Inc · Rock Falls, ILBuilt 1984 · S/N 28-8416051N4342EMoon Jonathan Edward · Butler, PABuilt 1978 · S/N 38-78A0564N4342MStout Lloyd J · Belmont, CABuilt 1947 · S/N 12-3280N4342XAlpha Aviation Inc · Mount Vernon, WAS/N 28R-7635015N4342ZCook Raymond L · Spring Grove, ILBuilt 1968 · S/N 18-8660N43431Upchurch James Stephen · Rockfield, KYBuilt 1974 · S/N 28-7425366N43434Bg Partners LLC · El Cerrito, CABuilt 1974 · S/N 28-7415491N4343QK M Air Enterprises Inc · Corona, CABuilt 1971 · S/N 17260243
Back to AD 90-04-06 R1