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.

N186CSFlying Rock Aero LLC · Sunnyvale, CABuilt 2011 · S/N 172S11087N186FMJett Aviation LLC · Clovis, NMFirst renewal noticeBuilt 1977 · S/N 17269339N1870VSanders-Smith Kimberly K · Napa, CABuilt 1974 · S/N 17263776N1871VMcpherson Philip D · Battle Creek, MIBuilt 1974 · S/N 17263777N18728Atlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 172S9929N1872YKamp Implement Co · Belgrade, MTBuilt 1962 · S/N 17249472N1873YTullier Mary A · Talihina, OKS/N 17249473N1874YCouncil Melvin · Squaw Valley, CABuilt 1962 · S/N 17249474N1875YBrotheridge Bryan R · Merritt Island, FLBuilt 1962 · S/N 17249475N187CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13102N187HAA&J Air Sales Inc · San Antonio, TXBuilt 1971 · S/N 17259696N187HSGlidewell Aviation Inc · Parkland, FLBuilt 2005 · S/N 172S9945N1881YSutton Aircraft Salvage LLC · Palmer, AKBuilt 1962 · S/N 17249481N1882SWings Over L A Aviation LLC · West Hills, CABuilt 2005 · S/N 172S9930N1882YDunlap Alexander W · Eads, TNS/N 17249482N1884MMontgomery Aviation LLC · Zionsville, INBuilt 2005 · S/N 172S9931N1884VMurphy Edward L · Fairmont, WVBuilt 1974 · S/N 17263781N1886VAngelone Inc · Elkhart, INBuilt 1974 · S/N 17263782N1889VCroome James Earl Jr · Sandersville, GABuilt 1974 · S/N 17263783N188AHAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13467N188VEFly Skyhawk LLC · Peoria, AZBuilt 2000 · S/N 172S8391N1891YCarolina Sky LLC · Rock Hill, SCBuilt 1962 · S/N 17249491N1892VSmith Air Inc · Ukiah, CABuilt 1974 · S/N 17263784N1892YBaker David Laurence · Nelson, WIS/N 17249492N1893YWhelan John J · Mount Vision, NYBuilt 1962 · S/N 17249493N1896YArmond Richard Joseph · Thousand Oaks, CABuilt 1962 · S/N 17249496N1897VBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263785N189WMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17255907N18ACHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 172S9737N18EBAll American Aviation LLC · East Helena, MTBuilt 1974 · S/N 17264188N18FGShapiro David Ely · Brookhaven, GABuilt 1974 · S/N 17264233N18HRJ & R Aviation LLC · Hamilton, OHBuilt 1967 · S/N 17256269N18JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1980 · S/N 17274513N18LWDirty Side Down Aviation LLC · Georgetown, TXBuilt 1998 · S/N 17280403N18STYoung Shawna Hodges · Turlock, CABuilt 1973 · S/N 17261795N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162N1905VNew Horizons Aviation Inc · Goshen, INBuilt 1974 · S/N 17263788N1906VN46132 LLC · Kalispell, MTBuilt 1974 · S/N 17263789N1908FMccloskey Cynthia · Matthews, NCBuilt 1973 · S/N 17256493N190FCook James H · Brookings, ORBuilt 1958 · S/N 46366N190LPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeBuilt 2002 · S/N 172S9190N190MEMenagerie Enterprises Inc DBA · Denison, TXBuilt 2012 · S/N 172S11190N1914VStephens Thomas E · Blacklick, OHBuilt 1974 · S/N 17263792N1915VBenac Brad James · Swansea, SCS/N 17263793N1916JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13182N1918VCampbell Kevin A · Grayville, ILBuilt 1974 · S/N 17263794N1919FUsda Forest Service Fepp · Columbia, SCBuilt 1979 · S/N 17273011N1919SBurgess Reilly M · Greene, MEBuilt 1974 · S/N 17263899N1919UD&S Aviation LLC · Spring, TXBuilt 2025 · S/N 172S13295N191ARJack Dixon Inc · Haiku, HIBuilt 1977 · S/N 17270069
Back to AD 90-06-03 R1