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.

N772RAKehmeyer Aviation LLC · Bronson, MIBuilt 1977 · S/N 17270013N7731TNash Leslie W · Bentonia, MSBuilt 1960 · S/N 47331N7731UMd Aviation Inc · Sioux Falls, SDBuilt 1964 · S/N 17251731N7732XLinstad Daniel E · Canby, ORBuilt 1960 · S/N 17248232N7733GWashingtons Mt St Helens Co Inc · Mill Creek, WAS/N 17259433N7733TSiu Ena · Reno, NVS/N 47333N7733UGutlon Richard S · Durham, NCBuilt 1964 · S/N 17251733N7734XNelson Daniel J · Ladd, ILBuilt 1961 · S/N 17248234N7736GKnudson Aviation LLC · Bozeman, MTS/N 17259436N7736UWatson Marshall · Sublette, KSS/N 17251736N7736XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 17248236N7737UMast Elroy T · Crawford, MSBuilt 1964 · S/N 17251737N7738GCurioso Enrique Martin · Irvine, CAFirst renewal noticeS/N 17259438N7738UGibson Nathaniel A · Cross Lanes, WVBuilt 1964 · S/N 17251738N7738XSutter William R · Hobart, WAS/N 17248238N7739GFlyguys 172 LLC · Liberty, NCBuilt 1970 · S/N 17259439N773AAAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13476N773AKKlausler Andrew T · New Market, MNBuilt 1972 · S/N 17260810N773BAMustang Sally Aviation LLC · Camden, SCBuilt 2001 · S/N 172S8773N773SPFox Flying Club Inc · Wheaton, ILBuilt 2001 · S/N 172S8702N7740XAnderson Vance K · Eugene, ORBuilt 1960 · S/N 17248240N7741GCaviness Dewayne · Chico, CABuilt 1970 · S/N 17259441N7742THelmuth Allen · Powell Butte, ORBuilt 1960 · S/N 47342N7742XMoore John W · Blue Earth, MNS/N 17248242N7744SVista Air Inc · Pacoima, CABuilt 1999 · S/N 172S8274N7744UArnold David L · Portland, ORBuilt 1964 · S/N 17251744N7745GSuperhawk N7745g Owners' Group LLC · Bend, ORBuilt 1970 · S/N 17259445N7745UHodges Charles E · Grain Valley, MOBuilt 1964 · S/N 17251745N7746TWilson Steven C · Raleigh, NCBuilt 1960 · S/N 47346N7746XHennings Noran E · Des Moines, WABuilt 1961 · S/N 17248246N7747GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259447N7747UCoastal Zoom LLC · Davenport, FLBuilt 1964 · S/N 17251747N7749LDouble Bridges Aviation LLC · Enterprise, ALBuilt 1970 · S/N 17259015N7749UN833tx LLC · Little Rock, ARBuilt 1964 · S/N 17251749N774LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13117N774MGPs Aviation Inc · Jackson, MNS/N 17269250N7750GVitt Edward J · Sewell, NJBuilt 1970 · S/N 17259450N7750UCoke Hartwell F · Quinton, VABuilt 1964 · S/N 17251750N7750XBurklund Joel H · Minneapolis, MNS/N 17248250N7751TBehl Nathan S · Lewistown, MTBuilt 1960 · S/N 47351N7752XCassell Peter B Jr · Stonewall, LABuilt 1961 · S/N 17248252N7753GCw Enterprise LLC · Jewell Ridge, VABuilt 1970 · S/N 17259453N7753THollis Scott C · Sumpter, ORBuilt 1960 · S/N 47353N7753UAmyx Hiram R · Liberty, TXBuilt 1964 · S/N 17251753N7754GRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1970 · S/N 17259454N7754XKendall David · Ferndale, CABuilt 1960 · S/N 17248254N7755GSagori Aviation LLC · Orlando, FLBuilt 1970 · S/N 17259455N7756XSkelton Air LLC · Lewiston, IDBuilt 1960 · S/N 17248256N7757THarris Seth · Ellensburg, WABuilt 1960 · S/N 47357N7757UTruitt Seth L · Cynthiana, KYBuilt 1964 · S/N 17251757
Back to AD 90-06-03 R1