OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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-06-03-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-06-03-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.

N1585YKovtun Andriy · Elmwood Park, NJBuilt 1962 · S/N 17249285N1587YFry William A · Willmar, MNBuilt 1962 · S/N 17249287N1588EGeaux Giddum 1 LLC · Brandon, MSBuilt 1978 · S/N 17271054N1588VC-140 Company LLC · Milton, FLBuilt 1974 · S/N 17263683N1589DN1589d LLC · Stuart, FLBuilt 2005 · S/N 17281255N158AERobinson Bruce A · Salinas, CABuilt 1962 · S/N 17249943N158PMLowrey Jonathan S · Jasper, INBuilt 1971 · S/N 17260064N158RAJohneco Inc · Beachwood, OHBuilt 1999 · S/N 17280805N158SFAlba Leasing Services LLC · Scottsdale, AZBuilt 2006 · S/N 172S10368N1590VWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17263684N1590WCc Aviation Inc · Tracy, CABuilt 2005 · S/N 17281256N1591EWingsleasing LLC · Wichita, KSBuilt 1978 · S/N 17271057N1591VAviation Academy LLC · Wichita, KSBuilt 1974 · S/N 17263685N1592VGates Kenneth A · Lake Isabella, CABuilt 1974 · S/N 17263686N1593VBarrie Woodrow L · Oxford, MIBuilt 1974 · S/N 17263687N1593YBolsover Douglas J · Cameron Park, CABuilt 1962 · S/N 17249293N1594UFarmer Michael E · Greer, SCBuilt 1976 · S/N 17267176N1594YSexson Lance Mason · Ogallala, NES/N 17249294N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060N1597YHelderman Laban W · Newton, NCBuilt 1962 · S/N 17249297N159AEGalbari Geno · Wales, WIS/N 17249954N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816N15AFRogers Jeff · Harrogate, TNBuilt 1976 · S/N 17267237N15ANAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13258N15FACivil Air Patrol · Maxwell Afb, ALBuilt 1978 · S/N 17270117N15FPFoxtrot Papa LLC · Slidell, LABuilt 1977 · S/N 17268574N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161N15HJMorehouse Cooper · North Pole, AKS/N 17268950N15MJRegistered aircraftBuilt 2024 · S/N 172S13005N15NFRegistered aircraftBuilt 1969 · S/N 17258204N15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 172RG0115N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875N1600UOsprey Holding Company LLC · Foley, ALBuilt 2005 · S/N 172S9905N1602BBoyd Aaron · S San Fran, CABuilt 1979 · S/N 17272737N1602FWilliams Richard E · Seaford, DEBuilt 1966 · S/N 17254997N1602VRegistration Pending · Lucas, TXRegistration pendingBuilt 1974 · S/N 17263690N1603EWright Michael A · Advance, NCBuilt 1978 · S/N 17271062N1603FAbouelleil Hisham · Suffield, CTS/N 17254998N1604FMorse Mark H · Lake Stevens, WABuilt 1966 · S/N 17254999N1604YOcean Isle Aviation · Ocean Isle Beach, NCBuilt 1962 · S/N 17249304N1606YFellows James S Jr · Fawnskin, CABuilt 1962 · S/N 17249306N1607FNurieva Asmar · New Smyrna Beach, FLBuilt 1966 · S/N 17255002N1608FSmith Tim J · Leasburg, MOBuilt 1966 · S/N 17255003N1608SNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S9907N1608YKohr Daniel E · Bartlett, TNBuilt 1962 · S/N 17249308N1609EEilenfeld Teresa · Mansfield, OHBuilt 1978 · S/N 17271065N1609YMapes Steven J · Schenectady, NYBuilt 1962 · S/N 17249309N160FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272752N160MESilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172S8440
Back to AD 90-06-03 R1