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.

N55AUWallner Chris R · Petaluma, CABuilt 2003 · S/N 60537N55BCMcconnell Bert J · Hudson, OHBuilt 2003 · S/N 60360N55CRUltrapure Air LLC · Setauket, NYBuilt 1997 · S/N 392N55DHAcmed Consulting LLC · Bradford, RIBuilt 1997 · S/N 24-3414N55DPMagaw David N · Sacramento, CABuilt 1974 · S/N DP-3N55DVDevine William L Jr · Maple Falls, WABuilt 1948 · S/N 14-192N55DYBrown Carl A · Las Cruces, NMBuilt 1992 · S/N 194N55DZHuey Christopher D · Mesa, AZS/N 9472004N55EDonnelly Mitch L · Mcloud, OKS/N BEA-1N55EKMengel David M · Monticello, INS/N 1568N55ELLynn Edward Wayne · Vancouver, WABuilt 2019 · S/N 25237N55EMIxi LLC · West Bloomfield, MIBuilt 1974 · S/N 28-7415328N55ERCavanaugh Flight Museum · Denison, TXBuilt 1968 · S/N 67-17098N55EWHanratty Brian James · Pismo Beach, CABuilt 1966 · S/N TD-681N55FFSiedschlag Paul C · Granbury, TXBuilt 1978 · S/N 24-0672N55GASaathoff Michael A · Stockton, MOS/N 541N55GBRivers Paul E · Shannon, ILBuilt 1979 · S/N 212056N55GGAll Attitude Aviation Inc · Edgewater, FLBuilt 1985 · S/N 1030N55GLBates John W · Westerly, RIBuilt 2016 · S/N GL-003N55GR55 Golf Romeo LLC · North Myrtle Beach, SCBuilt 1989 · S/N 1124N55GTTurner William Hugh Vi · Belmont, CABuilt 1979 · S/N 5N55HAHonaker Group LLC · Sellersburg, INS/N 17269194N55HBStefanick Richard L · Morgantown, WVBuilt 1972 · S/N MB001N55HNNaylor John H · Conway, ARS/N ONEN55HQHerndon Colton R · Smithville, MOBuilt 1965 · S/N 743N55HUKaihai Corp · Wilmington, DEBuilt 1999 · S/N 2046N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772N55JJPrivitt Bret · Fort Worth, TXBuilt 1974 · S/N 311-75N55KEMiller Charles A · Walla Walla, WABuilt 1990 · S/N 20081N55KLNewman John D · Clyo, GAS/N 968-1N55KRBaird Keith W · Marianna, FLBuilt 1975 · S/N 17702344N55LGWard Randy · Port Saint Lucie, FLS/N 17256728N55MAGodwin Gerald R · Kountze, TXBuilt 2005 · S/N 2316N55MDMcclure David F · Camp Hill, PABuilt 1976 · S/N 28-7790103N55MPCommanche LLC · Slatington, PAS/N 177RG0668N55NDMeyer William M · Chicago, ILBuilt 1976 · S/N 606HN55NPN55np LLC · Broomfield, COS/N 700010N55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793N55PHElectrical Design Consultants Group LLC · Pepper Pike, OHBuilt 2002 · S/N 0145N55PKGlasheen Sean T · Bethel, AKBuilt 2019 · S/N CC18-0096N55PMOrgis Brian E · Houston, TXBuilt 1987 · S/N 1558N55PNKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 28-7415251N55PTDejulia Thomas A · Seward, AKBuilt 1953 · S/N 18-2675N55PZVayda Douglas L · Crescent City, FLBuilt 2004 · S/N 9971CCN55QQWilliams John · Tuttle, OKBuilt 2005 · S/N 4807N55RCSmith Matthew E · Creston, IABuilt 1989 · S/N 288N55RDSchober David · Union Bridge, MDBuilt 1966 · S/N 30-1307N55RKSaunders Christopher D · Lehighton, PABuilt 1998 · S/N TD 2020N55STriple R Aviation LLC · Cleburne, TXBuilt 1965 · S/N TD-631N55SHTiedeman Craig L · Seven Bays, WABuilt 1998 · S/N 55-483103
Back to AD 90-04-06 R1