OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N34491Hazelwood Dennis L · Mount Vernon, MOBuilt 1972 · S/N 17701839N34496Ricco Umberto · Chicago, ILS/N L-14881N34497Harrison Vernon D · Crawford, TXS/N L-14841N3449MCarhart Thomas M · Galesville, WIBuilt 1977 · S/N 28R-7837114N3449THedrick Bill E · Kilgore, TXBuilt 1968 · S/N 17700749N344ATTagir Abkadirov · Tampa, FLS/N 1354N344CCDorsey Dale · Charlotte, NCBuilt 1995 · S/N 22084N344CRPattern Altitude Aviation Standards LLC · Sandy, UTS/N 28-153N344DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843832N344MARomeo Romeo LLC · Lewes, DEBuilt 2003 · S/N 40.344N344MCEuroaviation Inc · KematenBuilt 1973 · S/N 34-7450008N344RDSchab-Davis Margaret A · Spangle, WABuilt 2003 · S/N 02-PA18ABN344SPSun City Aviation LLC · Davie, FLBuilt 1999 · S/N 172S8267N344WBeck Tom E · Homer, AKBuilt 1946 · S/N 12-775N34500Miller Judy Carole · No Palm Beach, FLBuilt 1972 · S/N 17701843N34502Cardinal Primo LLC · Mesa, AZBuilt 1977 · S/N 177RG1296N34504Simons Douglas L · Eagle, MIBuilt 1941 · S/N L-14971N34506Tibbs Gary R · Marietta, GABuilt 1972 · S/N 17701846N3450AScootair LLC · Alburgh, VTBuilt 1953 · S/N 22-1719N3450XCarey Patrick M · Citrus Heights, CABuilt 1966 · S/N 1136N3451Hardt Daniel M · Eugene, ORBuilt 1978 · S/N 173N34511Mazure Glenn J · Bad Axe, MIBuilt 1972 · S/N 17701849N3451334513 LLC · Stanton, TNBuilt 1972 · S/N 17701851N34519Mccarthy James E · Yucca Valley, CABuilt 1972 · S/N 17701855N3451KMorehead Matt F · Chico, CABuilt 1967 · S/N 28-23559N3451MWilliamson Gary T · Ashmore, ILBuilt 1947 · S/N 12-2342N3451QCcr Holdings LLC · Rushford, MNBuilt 1977 · S/N 28-7725228N3451TMichael W Maciol Md · Pelham, NYBuilt 1968 · S/N 17700751N3451ZHarris Michael E · Greenville, SCS/N 22-7370N34520Thomas Robert B · Bristol, CTBuilt 1940 · S/N 4070TN34521Mitchell Robert A · Centennial, COBuilt 1972 · S/N 17701856N34522Batten Stanley · Arlington, MNBuilt 1941 · S/N LB14821N34524Registered aircraftBuilt 1972 · S/N 17701857N34528Mcmahon John · Sequim, WABuilt 1972 · S/N 17701859N3452AMolek Jon · Warren, OHS/N 22-1725N3452KRegistered aircraftBuilt 1967 · S/N 28-23561N3452TKordus Robert A · Union Grove, WIS/N 17700752N3452ZChief LLC · Du Quoin, ILBuilt 1960 · S/N 22-7371N3453MSmith Matthew M · Anchorage, AKBuilt 1947 · S/N 12-2340N3453QEdwards Latas L Jr · St Petersburg, FLFirst renewal noticeS/N 28-7716156N3453TAircraft Evolution LLC · Miami, FLBuilt 1968 · S/N 17700753N34541Carnegie Scott W · Saint Charles, MOBuilt 1941 · S/N F10151TN34543Riggs Jeffrey W · Claremore, OKBuilt 1973 · S/N 17701865N3454ABasler Leon E · Sainte Genevieve, MOBuilt 1953 · S/N 22-1723N3454CHenderson Eric R · Santa Rosa, CABuilt 1954 · S/N 26497N3454TTears Gary S · Edmond, OKBuilt 1968 · S/N 17700754N3454XGarcia Eduardo G · Houston, TXBuilt 1966 · S/N 1138N34552Mlinarich Rob · Pottsboro, TXBuilt 1973 · S/N 17701868N34554Maryland Industrial Trucks Inc · Linthicum, MDS/N 17701870N34555Cardinal Aviation LLC · Everett, WABuilt 1973 · S/N 17701871
Back to AD 90-04-06 R1