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.

N9137JYuma Piper Fliers · Yuma, AZBuilt 1966 · S/N 28-3190N91383Rieder Josh · Boone, NCBuilt 1981 · S/N 38-82A0021N91386Shred Box LLC · Hayesville, NCBuilt 1981 · S/N 38-82A0022N9138HMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265967N91396Willard Malcolm · Williston, VTBuilt 1995 · S/N 24-3355N9139TBoss Peter J · Bruce, WIBuilt 1968 · S/N M-1155N9139ZTseline Aleksei · Cary, ILBuilt 1992 · S/N 24-3285N913APeckenpaugh Dawson S · Worden, MTBuilt 1951 · S/N 22-219N913CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8333N913CSSeaman Bruce M · Mohave Valley, AZBuilt 2021 · S/N 71112N913CVMansfield Douglas M · East Gull Lake, MNBuilt 2002 · S/N CV-3N913FBrooks Benjamin · Little Rock, ARBuilt 1991 · S/N 1801N913GSStull Gary L · Lutz, FLBuilt 2001 · S/N 317N913HCRosoff Neil M · Scotch Plains, NJBuilt 2019 · S/N 92081N913JKKing Michelle L · Atlanta, GABuilt 1974 · S/N 1018-74N913LKKeller Logan · Vale, ORBuilt 2021 · S/N 70MN913MSCukovic Naim · Portsmouth, NHBuilt 1976 · S/N 28-7715094N913PCRodgers Contract Cutting Inc · Eagle Point, ORS/N 67-16857N913TAChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15285317N913TGThomas Home Center Inc · Sheridan, ORBuilt 1985 · S/N 28-8616011N913VBCafarelli Peter · Livingston, TXBuilt 1974 · S/N 5001CN913WCPotts Seth A · Mabank, TXBuilt 2009 · S/N 81042N913WGGan Thomas W · Doylestown, PABuilt 2013 · S/N 91887N914Daiber Marcus · Jefferson, GABuilt 1972 · S/N 388HN9140DLee Gerald R · Glennallen, AKBuilt 1958 · S/N 18-6529N9140JKeller Michael A · South Lake Tahoe, CABuilt 1966 · S/N 28-3194N9140LPretorius Ellen T · Smithville, OHBuilt 1971 · S/N 807-71N9140TKay Aviation LLC · Merritt Island, FLBuilt 1968 · S/N M-1156N9140VN914ov LLC · Greensboro, NCBuilt 1969 · S/N 690028N9140XScoffield Russell C · Hayden, IDBuilt 1991 · S/N 24-3245N91414Richardson James R · Brandon, MSBuilt 1981 · S/N 38-82A0027N9141JArvizu Alberto P · Lake Havasu, AZS/N 28-3195N9141LAmerican Airpower Heritage Flying Museum · Dallas, TXS/N 808-71N9141RInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 1323N9141VFlitton Mark S · Enterprise, ALS/N 690010N9142JKormash John A · Edgewater, FLBuilt 1966 · S/N 28-3196N9142KSwales Michael K · Harrisville, MIBuilt 1976 · S/N 28-7615177N9143DHellberg Farms LLC · Lowden, WAS/N 18-6533N9143JN9143j LLC · Fort Wayne, INBuilt 1966 · S/N 28-3197N9143SBooton Charles E · Navarre, FLBuilt 1975 · S/N MC-397N9143VCrazy Mountain Cub LLC · Helena, MTBuilt 1988 · S/N 1809002N9144TShiflett Philip B · Marietta, OHBuilt 1985 · S/N 28-8690029N9144VHardin Ralph · New Plymouth, IDBuilt 1969 · S/N 690029N9145JBonertz Brian J · Muscatine, IAS/N 28-3200N9145VRoe Cameron · Salt Lake City, UTBuilt 1969 · S/N 690011N9146DSmith Paul G · Wasilla, AKBuilt 1958 · S/N 18-6536N9146JSwarey Steven · Whiteville, TNBuilt 1966 · S/N 28-3201N9146KBartlett Jesse Charles · Henderson, NVBuilt 1976 · S/N 28-7615178N9146LMalone Aaron E · Wasilla, AKS/N 812-71N9146VWood David Allen · Conyers, GABuilt 1969 · S/N 690025
Back to AD 90-04-06 R1