OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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.

N9534HBotezatu Florin · Gig Harbor, WABuilt 1975 · S/N 17266208N9535HNorthwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17266209N9536DCalifornia Management And Consulting LLC · North Hollywood, CABuilt 1998 · S/N 17280481N9536HSampson Kelly J · Canby, ORS/N 17266210N9537LPence Jeffrey S · Edinburg, VABuilt 1986 · S/N 17276571N9537QBoeing Empolyees Flying Assn · Renton, WABuilt 1998 · S/N 17280483N9538HK & L Air Inc · Brazil, INBuilt 1975 · S/N 17266212N9539BThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1981 · S/N 172RG0865N953ACConeburripul Corp · Miami, FLBuilt 1998 · S/N 17280549N953AFRegistration Pending · Addison, TXRegistration pendingBuilt 2026 · S/N 172S13567N953SMBogen Alfred T · Brandon, MSBuilt 1980 · S/N 172RG0772N9540BFly8ma LLC · Big Lake, AKBuilt 1981 · S/N 172RG0866N9540LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276574N9542BSoileau Kenneth B · Lancaster, SCBuilt 1981 · S/N 172RG0867N9542HAbusham Hamed M · Upland, CABuilt 1975 · S/N 17266215N9543HGonzalez-Rio Jesus A · Big Pine Key, FLBuilt 1975 · S/N 17266216N9543PHerr Bridget J · Boles, ARBuilt 1999 · S/N 17280644N9544HSouthern Aero LLC · Homestead, FLBuilt 1975 · S/N 17266217N9545BSunrise Aero Inc · Ocala, FLBuilt 1981 · S/N 172RG0870N9545FEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280380N9546HMiller Dale L · Bozeman, MTBuilt 1975 · S/N 17266219N9547LCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 17276575N9547WWatch Ya Head Aviation I LLC · Zionsville, INBuilt 1998 · S/N 17280508N9548WZh Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280512N9549FJogger Industries LLC · Sherwood, NDBuilt 1998 · S/N 17280514N9549HBenson Edward A · San Antonio, TXBuilt 1975 · S/N 17266221N954ACAir Future Airways Corp · Miami, FLBuilt 1997 · S/N 17280053N954FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13279N954JAAdvanced Aviation Group LLC · Frederick, MDS/N 172S10500N954JHWings Over Texas LLC · Denton, TXBuilt 1975 · S/N 17266220N9550BMccall Freddie W · Brewton, ALBuilt 1981 · S/N 172RG0872N9550GCopper Skies Aviation LLC · Mesa, AZBuilt 1998 · S/N 17280516N9550QDecatur Aero Club Inc · Decatur, ILBuilt 1998 · S/N 17280517N9550SBald Eagle Enterprises Inc · Nashville, TNBuilt 1999 · S/N 17280758N9551BLopes Gaston A · Dallas, TXS/N 172RG0873N9552AAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280531N9552HZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1975 · S/N 17266223N9552VRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17264354N9553ATitusville Aero Club Inc · Titusville, PABuilt 1998 · S/N 17280376N9554VCavu LLC · Fort Collins, COBuilt 1974 · S/N 17264356N9555HWilkinson William · Anchorage, AKBuilt 1975 · S/N 17266226N9556VMiles James D · Memphis, TNBuilt 1974 · S/N 17264358N9557BGibson Robert B · Los Alamos, NMBuilt 1981 · S/N 172RG0879N9557VSkyhawk 57v Inc · Pittsburgh, PABuilt 1974 · S/N 17264359N9559DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280488N9559SElizabeth Dloda LLC · Hilton Head Island, SCBuilt 1998 · S/N 17280490N9559VOcm Aviation LLC · Buckeye, AZBuilt 1998 · S/N 17280491N955ACNaples Air Center Inc · Naples, FLBuilt 2001 · S/N 172S8984N955CCN955cc LLC · Estero, FLBuilt 1969 · S/N 17258826N955CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12157
Back to AD 90-06-03 R1