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.

N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561N7261WKurywchak Daniel A · Cameron Park, CABuilt 1963 · S/N 28-1093N7261YKocak Robert G Jr · Peoria, AZBuilt 1964 · S/N 30-295N7262FParlee Chad E · Lakeport, CABuilt 1968 · S/N 28-25181N7262JKemp Lyman E · Ketchikan, AKBuilt 1968 · S/N 28-24584N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562N7262WDube Colin T · Minot, MEBuilt 1963 · S/N 28-1095N72639Dischler Stephen · New Lisbon, WIBuilt 1999 · S/N 17280806N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963N7263JKl Aviation LLC · Catawba, NCBuilt 1968 · S/N 28-24548N7263PHoffman Raymond F · Encinitas, CABuilt 1960 · S/N 24-2439N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563N7263WKontour Shawn K · Wheatland, WYBuilt 1963 · S/N 28-1096N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1964 · S/N 30-298N7264Godsil Donivan · Oneida, ILS/N 75-458N7264FPodyaire LLC · Ruston, LAS/N 28-25184N7264JHoseney Richard W Jr · Como, MSBuilt 1968 · S/N 28-24532N7264LLarson Aircraft LLC · Sandy, UTBuilt 1972 · S/N AA1A-0464N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564N7264WFehringer John T · Sidney, NES/N 28-1097N7264YYogi Air LLC · Wadsworth, OHBuilt 1964 · S/N 30-299N72650Mecham Gerald W Jr · Mesa, AZBuilt 1946 · S/N 9826N72653Atp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280807N7265BHolladay Aviation LLC · Jacksonville, FLBuilt 1999 · S/N 17280749N7265FShouling & Philip Enterprise · Lancaster, CAS/N 28-25185N7265JSwoboda Charles · Anchorage, AKBuilt 1968 · S/N 28-24528N7265KSale Reported · Phoenix, AZSale reported, canceledBuilt 1950 · S/N 18-158N7265LGulfstream Aerospace Corp · Savannah, GABuilt 1972 · S/N AA1A-0465N7265WSayles Michael A · Shorewood, ILBuilt 1963 · S/N 28-1098N7265ZAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280769N72662Jwa Flight School LLC · Bolingbrook, ILBuilt 1999 · S/N 17280817N72664Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280818N7266DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272912N7266JPaolo Keath R · Carlton, ORBuilt 1968 · S/N 28-24520N7266QLima-001 LLC · Muscatine, IABuilt 1972 · S/N 17260566N7266WNewland Hunter R · West Valley City, UTBuilt 1963 · S/N 28-1099N7267FRegistered aircraftBuilt 1968 · S/N 28-25187N7267GWells Jack D · Newtown, MOBuilt 1970 · S/N 17258967N7267JSe Aviation LLC · Boise, IDBuilt 1968 · S/N 28-24464N7267WGillespie Michael Lee · Jacksonville, FLBuilt 1963 · S/N 28-1185N72681Riggs Benjamin D · Reynoldsburg, OHBuilt 1946 · S/N 9857N7268DLarsen Daniel R · Kenai, AKBuilt 1957 · S/N 18-5676N7268LFletchair Inc · Comfort, TXS/N AA1A-0468N7269FChandler Joseph · Amana, IABuilt 1968 · S/N 28-25191N7269GBranson Barry R · Shasta Lake, CABuilt 1970 · S/N 17258969N7269QBaker Mark · White Bear Lake, MNBuilt 1972 · S/N 17260569N7269WButtercup Express LLC · Woodward, OKS/N 28-1103N726ACGrass Roots Aviation LLC · Bend, ORBuilt 1999 · S/N 1276-99N726AJStarr Alan D · Senoia, GABuilt 1969 · S/N 17701378N726AMRegistered aircraftBuilt 1953 · S/N 26009
Back to AD 90-04-06 R1