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.

N8288EGomez Cierra D · Jasper, ALS/N 17272174N8288FAtwood Jason P · La Porte, INBuilt 1976 · S/N 28-7790237N8288JRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1979 · S/N VAC-134-79N8288LFrenzel Aviation Investments LLC · Brentwood, TNBuilt 1980 · S/N 28R-8118011N8288ZPabon Hugo · Granada Hills, CABuilt 1980 · S/N 28-8116071N8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 28-8116072N8289CSchilder Justin W · Faulkton, SDBuilt 1954 · S/N 18-3699N8289GDutcher Kenneth J · Kingsland, TXS/N 177RG0189N8289JCummings Steven R · League City, TXS/N VAC-135-79N8289XSheitelman Mitchell · Warren, NJBuilt 1980 · S/N 28-8190080N828AYoder Stephen · Melba, IDBuilt 1951 · S/N 22-130N828BMChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280134N828BNTravelaire Service Inc · Pueblo, COBuilt 2004 · S/N 82058N828DMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N MCPHAIL-0001N828FSPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1999 · S/N 17280794N828HPParsons Harry · Bloomfield, NJBuilt 1986 · S/N 898N828HTHappy Trails Aviation LLC · Kalispell, MTBuilt 2022 · S/N 3404N828JPCarney William F · Gallatin, TNBuilt 1957 · S/N 185460N828JTAtems Elisabeth · Northfield, VTBuilt 1976 · S/N 177RG0945N828LPFlying Twenties Inc · San Jose, CABuilt 2001 · S/N 172S8828N828LSKelly Ryan · New York, NYBuilt 1977 · S/N AA5A-0406N828LUMuldrow Erik · Newport, KYBuilt 1958 · S/N 23-1373N828MCHub City Aviation Academy LLC · Lubbock, TXBuilt 1968 · S/N 28-4615N828PLGrosso Michael F · Charleston, SCS/N TD-549N828RVNewman Charles W · Petaluma, CABuilt 2001 · S/N 80959N828RWStankie Alexander M · Cocoa Beach, FLBuilt 2004 · S/N 24461N828SPVista Aviation Inc · Pacoima, CABuilt 2001 · S/N 172S8741N828TSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1988 · S/N 828N828YLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268168N82905Reese Melissa A · Soldotna, AKBuilt 1977 · S/N 18-7709197N82907Law Offices Of David Henderson · Anchorage, AKBuilt 1978 · S/N 18-7909031N8290CMckinney Steve R · Hamersville, OHBuilt 1954 · S/N 20-1119N8290JSchaaf Rodney B · Bowman, NDBuilt 1979 · S/N VAC-136-79N8290NHorne Larry E · Suffolk, VABuilt 1969 · S/N 28-25508N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890N8290WCastles James D · Portland, ORBuilt 1965 · S/N 28-2452N82912Barrows Stuart L · Eagle River, AKBuilt 1977 · S/N 18-7709195N82918Herman Brant · Fairbanks, AKBuilt 1977 · S/N 18-7809024N8291CStober John · Goodrich, NDBuilt 1954 · S/N 22-2356N8291ERangers Flying Club Inc · Eden Prairie, MNBuilt 1979 · S/N 17272177N8291GBullock Brooks M II · Cartersville, GABuilt 1971 · S/N 177RG0191N8291JWorth William A · Anthony, NMBuilt 1979 · S/N VAC-137-79N8291NPeters Rodney A Jr · Hayward, WIBuilt 1969 · S/N 28-25509N8291WVoll Dorothe A · Corona, CABuilt 1965 · S/N 28-2454N82921New Hampshire Flying Association Inc · Nashua, NHBuilt 1982 · S/N 28-8390007N8292DHuffman Jacob M III · Burleson, TXBuilt 1982 · S/N 28-8316009N8292EP&N Corp · Marion, IAS/N 17272178N8292JBrent Scott Properties Lp · Eagle, COS/N VAC-138-79N8292WPinegar Kevin R · Brighton, MIBuilt 1965 · S/N 28-2455N8293CMcchargue Robert W II · Talkeetna, AKS/N 18-4114
Back to AD 90-04-06 R1