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.

N6804XSusanville Aviatiors Inc · Susanville, CABuilt 1960 · S/N 47704N6806ELeeper Ramon J · Albuquerque, NMBuilt 1978 · S/N 17272070N6807ANelson Jason P · Childress, TXBuilt 1956 · S/N 28907N6808AShaak John C · Newnan, GABuilt 1956 · S/N 28908N6809ACottrell Lee D · Brownfield, TXBuilt 1956 · S/N 28909N680JFDunham Transport Inc · Wannaska, MNBuilt 1966 · S/N 17255246N680MAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8202N6810XIdaho Flyers LLC · Buhl, IDBuilt 1960 · S/N 47710N6811HJohnson Larry P Jr · Waynesville, GABuilt 1975 · S/N 17265591N6812AMoores Aerospace Solutions LLC · Statesboro, GABuilt 1956 · S/N 28912N6812XBig Sky Aviation Inc · Wilmington, DEBuilt 1960 · S/N 47712N6813ADenman David H · Gainesville, FLBuilt 1956 · S/N 28913N6814HUniform Gulf Aviation LLC · Williamstown, NJBuilt 1975 · S/N 17265594N6815AN6815a LLC · Allegan, MIBuilt 1956 · S/N 28915N6817ACerminara Giovanni · Belleview, FLBuilt 1956 · S/N 28917N681CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11538N681DCDoodle Air LLC · San Jose, CABuilt 2016 · S/N 172S11681N681DWSunrise Aviation Inc · Ormond Beach, FLBuilt 2000 · S/N 17280942N681EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13572N681MAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8203N681RLWeatherby Thomas M · Rcho Sta Marg, CAS/N 28633N6821AArmiger Scott Linwood · Holly Springs, NCBuilt 1956 · S/N 28921N6821XTudorani Vincenzo C · Las Vegas, NVS/N 47721N6822AStewart Brock Allen · Bartlett, TNBuilt 1956 · S/N 28922N6823AWilliams Daniel H · Fort Mcdowell, AZBuilt 1956 · S/N 28923N6823HClay Howard C II · San Francisco, CAS/N 17265596N6823XTipton Wendell D · Anchorage, AKBuilt 1960 · S/N 47723N6824AChristenson Robert E · Anacortes, WABuilt 1956 · S/N 28924N6825ABarker Jason · Hampton Falls, NHBuilt 1956 · S/N 28925N6827XCalderon Daniel C · Castro Valley, CABuilt 1960 · S/N 47727N6829ABaker Elbert W · Beckley, WVBuilt 1956 · S/N 28929N6829XZeegers Jozef · Bellingham, WABuilt 1960 · S/N 47729N682CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11539N682DWMach X Aviation LLC · Weston, FLBuilt 2000 · S/N 17280943N682MAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8204N682PBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12963N6830ALange Cole K · Oglala, SDBuilt 1956 · S/N 28930N6831ASale Reported · Pullman, WASale reportedS/N 28931N6831HQuarry Jon C · Memphis, TNBuilt 1975 · S/N 17265600N6832XOwens Philip A · Maryville, TNBuilt 1960 · S/N 47732N6833AChapter 163 Flying Club · Las Vegas, NVBuilt 1956 · S/N 28933N6835ABaratka Darin W · Phillips, WIBuilt 1956 · S/N 28935N6835HIowa Lakes Community College · Estherville, IABuilt 1975 · S/N 17265602N6836ARiner Mark G · Bartlesville, OKBuilt 1956 · S/N 28936N6836XNelson John D · Sonora, CABuilt 1960 · S/N 47736N6837ANorth Nathan A · Damascus, MDBuilt 1956 · S/N 28937N6839XCripe Rodney J · Middlebury, INBuilt 1960 · S/N 47739N683CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11540N683HBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12574N683HDFord Dwight M · Gig Harbor, WAS/N 17250499
Back to AD 90-06-03 R1