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.

N706DEBradley Aircraft Company LLC · Columbus, INBuilt 1979 · S/N 17272596N706LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11472N706SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13576N7070GGade Christopher P · Williston, VTFirst renewal noticeBuilt 1969 · S/N 17258770N7071AFieldman Gregory S · Olympia, WABuilt 1956 · S/N 29171N7071GWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258771N7071QSun Country Aero Club · The Villages, FLS/N 17260371N7072ABig R Of Greeley · Greeley, COS/N 29172N7072GMears Benjamin W III · Eastville, VABuilt 1969 · S/N 17258772N7072QB&R Aircraft LLC · Wadsworth, OHS/N 17260372N7072TFlaugher P Diane · Beloit, WIBuilt 1959 · S/N 46672N7073GSky Warriors LLC · Hayward, CAS/N 17258773N7073KCopper River Airmotive LLC · Copper Center, AKS/N 17271690N7074AFogg Morgan T · Pierce, COBuilt 1956 · S/N 29174N7074TNielson Dean A · Inchelium, WABuilt 1959 · S/N 46674N7074ZCopper River Airmotive LLC · Copper Center, AKS/N 17274467N7075AStonebrink Arnold · Payson, AZS/N 29175N7075GDraper Floyd L · El Paso, TXBuilt 1969 · S/N 17258775N7075QCorell Ryan J · Mason City, IAS/N 17260375N7076QAbbott Brett C · Leawood, KSBuilt 1972 · S/N 17260376N7076TLuebke Harold W Jr · Stuttgart, ARBuilt 1959 · S/N 46676N7079ADerbe LLC · Durham, NCBuilt 1956 · S/N 29179N707ATSpacely Space Sprockets LLC · Aurora, ORBuilt 1977 · S/N 17268611N707JYBest Glide LLC · Davie, FLS/N 17253465N707LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11473N707PPattison Bradley D · Gig Harbor, WABuilt 1975 · S/N 17266295N707PDTfs Air LLC · Loveland, COBuilt 2000 · S/N 172S8389N707UJInternational Air Services Inc Trustee · Carson City, NVS/N 17262019N7080ARedmon Michael P · Canal Winchester, OHBuilt 1956 · S/N 29180N7080QFerraro Paul · Seattle, WABuilt 1972 · S/N 17260380N7080TKingdom Planes LLC · Decatur, TXBuilt 1959 · S/N 46680N7081ASeibert Edwin M · Swansea, SCBuilt 1956 · S/N 29181N7081TYanez Manuel R · Calexico, CAS/N 46681N7082GBbt Inc · Wilmington, DEBuilt 1969 · S/N 17258782N7082QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260382N7082TGarrett Kasey L · Wilder, IDS/N 46682N7083GMassie Robert G · Whitewater, WIBuilt 1969 · S/N 17258783N7083QSevensixzerozero LLC · Boerne, TXBuilt 1972 · S/N 17260383N7084ABaldwin Glen R · Culdesac, IDS/N 29184N7084QMarcks Jason M · Shiocton, WIFirst renewal noticeS/N 17260384N7084THeitkamp Douglas C · Barney, NDS/N 46684N7085GRegistered aircraftBuilt 1969 · S/N 17258785N7085TKelley Geoffrey A · Wichita, KSBuilt 1959 · S/N 46685N7086ATugmon Danny Lee · Locust Grove, OKBuilt 1956 · S/N 29186N7086GSniffen Wesley H · Sycamore, OHBuilt 1969 · S/N 17258786N7087GRavindran Manoj · Clarksville, TNBuilt 1970 · S/N 17258787N7087TLakelands Flyers LLC · Greenwood, SCS/N 46687N7088DShoup Greg L · Pierre, SDBuilt 1961 · S/N 17248392N7088GSardeis LLC · River Hills, WIS/N 17258788N7089ARuotsi Tony M · Beaver Island, MIBuilt 1956 · S/N 29189
Back to AD 90-06-03 R1