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.

N3728RRaks Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 17255528N3729FPena Miguel A · Live Oak, FLS/N 17255224N3729LWells Timothy P · Raynham, MAS/N 17253898N372AHRegier Tom · Dinuba, CABuilt 2006 · S/N 172S10156N372BHLewis University · Romeoville, ILBuilt 2006 · S/N 172S10110N372GGIal Corp · Lewes, DEBuilt 1981 · S/N 17274926N372HBUnited States Air Force 21 Force Support Squadron · Colorado Springs, COBuilt 2005 · S/N 172S9983N372SAJoe Wagner IV Construction LLC · Zebulon, NCBuilt 1979 · S/N 17272854N372TADap Aviation LLC · Reston, VABuilt 2006 · S/N 172S10372N372TWTom Wood Aviation · Fishers, INBuilt 2015 · S/N 172S11632N3730RChief Joseph Flyers Inc · Joseph, ORBuilt 1966 · S/N 17255530N3731LSturguess James K · Boonville, MOS/N 17253900N3731SHerzfeld-Van Dyke Holly A · Conway, ARBuilt 1963 · S/N 17250931N3732LSumma Dawn K · Medina, OHBuilt 1965 · S/N 17253901N3732SMccague Kelly M · Las Cruces, NMBuilt 1963 · S/N 17250932N3733FBurch Samuel Owen · Roxboro, NCBuilt 1966 · S/N 17255228N3733LHillstrom Rudolph A · Oakville, WABuilt 1965 · S/N 17253902N3733RCouick Donald Michael · Monroe, NCBuilt 1966 · S/N 17255533N3733SBrn Technical Inc · Boca Raton, FLBuilt 1963 · S/N 17250933N3734LBertrand Todd A · Anchorage, AKBuilt 1965 · S/N 17253903N3735FEb Flight Training LLC · Daytona Beach, FLBuilt 1966 · S/N 17255230N3735SBeucler Brian G · Sandown, NHFirst renewal noticeBuilt 1963 · S/N 17250935N3738LTran Tuan M · Canton, MIBuilt 1965 · S/N 17253907N3739FSchlueter Helmuth K · San Tan Valley, AZS/N 17255234N3739LMattson David G · Lake Park, MNBuilt 1965 · S/N 17253908N3739RRusak Robert J · Paris, TXBuilt 1966 · S/N 17255539N3740FLavalley Asset Management · Potsdam, NYBuilt 1966 · S/N 17255235N3740RRhodes Samuel R · Bonne Terre, MOBuilt 1967 · S/N 17255540N3740SGarnsey Zene P · Schuylerville, NYBuilt 1963 · S/N 17250940N3741FMclanahan John P · Culpeper, VAS/N 17255236N3741RAbecca Corp · Jackson, MIBuilt 1966 · S/N 17255541N3742SHand Jerry A · Nacogdoches, TXBuilt 1963 · S/N 17250942N3743FRohde William B · Homer, NEFirst renewal noticeBuilt 1966 · S/N 17255238N3743LAero Flight Two LLC · Peoria, AZS/N 17253912N3744LAir Jeffery LLC · Aledo, TXBuilt 1965 · S/N 17253913N3744YKt 2022 LLC · Broomfield, COBuilt 2020 · S/N 172S12435N3745LMaxey Lonnie C · Powell, TNBuilt 1965 · S/N 17253914N3745RDodds Timothy E · Salmon, IDBuilt 1966 · S/N 17255545N3745SKondel Eugene F · Owosso, MIBuilt 1963 · S/N 17250945N3746LBygd Sherman O · New Richmond, WIBuilt 1965 · S/N 17253915N3746RPearson Eric · Wills Point, TXS/N 17255546N3747LN3747l LLC · Sonora, CABuilt 1965 · S/N 17253916N3747SToland Wesley H · Warrenton, ORBuilt 1963 · S/N 17250947N3748FMcdonald David R · Duluth, MNS/N 17255243N3748RRotormate LLC · Royse City, TXBuilt 1966 · S/N 17255548N3748SGeminiair Inc · Davis, CABuilt 1963 · S/N 17250948N3749FLeduc Kramer LLC · Live Oak, FLBuilt 1966 · S/N 17255244N3749LWilcox James F · Garrison, NDBuilt 1965 · S/N 17253918N374MASeatown Air LLC · Seattle, WABuilt 1999 · S/N 172S8076N374SAFloris Flight Services LLC · Midland, TXBuilt 2013 · S/N 172S11274
Back to AD 90-06-03 R1