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.

N608FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916328N608GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881194N608MABair Jay D · Ephrata, WABuilt 2012 · S/N 91562N608PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841217N608SCovey John R · Amboy, MNS/N 1030N6090BPlane Fun Inc Tr Trustee · Snellville, GABuilt 2000 · S/N 857N6090DWoolard Wayne W · Bath, NCBuilt 1956 · S/N 18-5450N6090FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020155N6090LDarcor Inc · Hampstead, NCBuilt 1972 · S/N AA5-0190N6090VRoberts Jon J · Parker, COBuilt 1980 · S/N 172RG0573N6090XAstle James H · Saint John, KSBuilt 1960 · S/N 1688N6091DMentone Flying Club · Rochester, INBuilt 1979 · S/N 17272599N6091FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020156N6091LMartino John F · Kingston, NYBuilt 1972 · S/N AA5-0191N6091MGollobit Matthew W · Pierce, NEBuilt 1998 · S/N 1N6091QBridges Jeffrey Kemp · Cumming, GABuilt 1965 · S/N 912N6091VJames Jay C · Mesa, AZBuilt 1980 · S/N 172RG0574N60924Interior & Arctic Alaska Aeronautical Foundation · Fairbanks, AKS/N 1425N6092DTanner Flying Service Inc · Cortez, COS/N 18-5459N6092FJasper Aviation Inc · Jasper, ALBuilt 1979 · S/N 17273146N6092MSchmucker Daniel · Bryn Athyn, PAS/N 15284619N6092VAir Venture LLC · Au Gres, MIBuilt 1980 · S/N 172RG0575N6092WBoling Bret J · Wichita, KSS/N 28-20106N6093Dory Joseph A · Star, IDBuilt 2006 · S/N ED001N60938Thomas Michael F · Glennallen, AKS/N 15070679N6093JAir S & T LLC · San Juan Capo, CAFirst renewal noticeBuilt 1980 · S/N 17273856N6093WLee Richard L · Bowie, TXBuilt 1964 · S/N 28-20107N6094DVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1958 · S/N 18-5461N6094FBuiqui Aerospace Corp · Kissimmee, FLBuilt 1979 · S/N 17273147N6094NAmerican Aviator LLC · Arlington, TXBuilt 1968 · S/N MA-336N6094QRakes Bobby N Jr · Saint Robert, MOBuilt 1965 · S/N 3261N6094RBoston Executive Helicopters LLC · Norwood, MABuilt 1979 · S/N M-2209N6095SAri Ben Aviator Inc · Fort Pierce, FLBuilt 2007 · S/N 2843662N6096FColeman Gregory M · Chewelah, WABuilt 1966 · S/N 7ECA-352N6096LC&C Airlines LLC · Mesa, AZBuilt 1972 · S/N AA5-0256N6096XBergman James H · Buckley, WAS/N 1694N6096ZYoung Collin H · Spring, TXBuilt 2010 · S/N 2843678N6097FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020157N6097LPetrovich Michael · Simpsonville, SCBuilt 1972 · S/N AA5-0257N6097MPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284621N6097PGuest Aviation LLC · Crane Hill, ALBuilt 1959 · S/N 24-765N6097WWallette Robert Michael · Port Saint Lucie, FLBuilt 1964 · S/N 28-20111N6098DShurtleff Russell D · Tunkhannock, PABuilt 1979 · S/N 17272602N6098FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020158N6098LGrosvenor Robert I · Belle, MOBuilt 2000 · S/N 25891N6098NRegistered aircraftBuilt 1968 · S/N MB-395N6098WFall Line Aviation LLC · Augusta, GAS/N 28-20112N6099QBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 3263N6099XStar Larry D · Gold Hill, NCBuilt 1960 · S/N 1700AN609DCBarber Aircraft LLC · Topping, VABuilt 1975 · S/N 17265563
Back to AD 90-04-06 R1