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.

N79315Waco Aircraft Partners LLC · Mc Gregor, TXBuilt 1969 · S/N 17258040N79316C & B Flying Club LLC · Camden, ARFirst renewal noticeBuilt 1969 · S/N 17258041N79318Pace Glen M · Columbia, MSBuilt 1969 · S/N 17258043N7931VFerguson Brent M · Reynoldsburg, OHBuilt 1969 · S/N 17258036N79321Registered aircraftBuilt 1969 · S/N 17258046N79323Carstairs Energy Inc · Los Osos, CABuilt 1976 · S/N 17268133N79325Gill Sandeep S · Southlake, TXS/N 17258050N7933BHudson Charles P · Sumrall, MSBuilt 1957 · S/N 29733N7934G7550g LLC · Birmingham, MIBuilt 1970 · S/N 17259634N7934UGreene County Holdings LLC · Cohoes, NYS/N 17251934N7934XBellmann Carl W · Bryan, OHBuilt 1961 · S/N 17248434N7935BCollins Timothy L · Caldwell, IDBuilt 1957 · S/N 29735N7936GWatson Carlton D · Campbellsville, KYBuilt 1970 · S/N 17259636N7938GDelaney Patrick James · Marion, TXBuilt 1970 · S/N 17259638N7938UFearnow Rolland E · Wabash, INS/N 17251938N7939BChristmas Gabriel K · Fairbanks, AKBuilt 1956 · S/N 29739N7939GMilton Alvah E II · Surrency, GABuilt 1970 · S/N 17259639N7939XCox Richard H III · Kapolei, HIBuilt 1961 · S/N 17248439N793FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13173N793PTCappe Investment Group LLC · Homestead, FLBuilt 1975 · S/N 17263842N793SPLeading Edge Aviation Inc · Doylestown, PABuilt 2001 · S/N 172S8718N793WTRaritan Valley Flying School · Princeton, NJBuilt 1997 · S/N 17280080N7940BHerbert Khristopher L · Tulsa, OKBuilt 1957 · S/N 29740N79410N79410 LLC · Tupelo, MSBuilt 1969 · S/N 17258061N79412Talley William B · Bakersfield, MOBuilt 1969 · S/N 17258063N79416Greene Tammy G · Alpharetta, GAS/N 17258067N79417Lhotka Tim · Silver Lake, MNBuilt 1969 · S/N 17258068N79418Lee Steven W · Somerset, KYBuilt 1969 · S/N 17258069N7941BTetrahedron LLC · Layton, UTS/N 29741N7941GPressley Aviation LLC · New London, NCBuilt 1970 · S/N 17259641N7941XDixie Aerial Surveillance & Photography LLC · Heflin, LABuilt 1961 · S/N 17248441N79420Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 17258071N79421Kauer Roy A · Millington, MIBuilt 1969 · S/N 17258072N79428Mindset Dynamics LLC · Las Vegas, NVBuilt 1969 · S/N 17258077N79429Hinds Community College · Bolton, MSBuilt 1969 · S/N 17258078N7942BPuckett Jeffrey F · Rector, ARBuilt 1957 · S/N 29742N7942GFlycarolina LLC · Rock Hill, SCBuilt 1970 · S/N 17259642N79431Brown Joshua W · Pomona, ILBuilt 1969 · S/N 17258080N79432N7037g Inc · Wilmington, DEBuilt 1969 · S/N 17258081N79434Gilpin Jeffrey · Portland, ORBuilt 1969 · S/N 17258083N79435Pearce Gregory W · Eagle River, AKBuilt 1969 · S/N 17258084N79436Granskog Gary L · Chico, CABuilt 1969 · S/N 17258085N7943BMoul Dale E · Boise, IDBuilt 1956 · S/N 29743N79440Spatiumtech LLC · Madison, ALBuilt 1969 · S/N 17258089N79442Friedmann David · San Diego, CABuilt 1969 · S/N 17258091N79445Raniolo James · Jackson, WYBuilt 1969 · S/N 17258094N79447Aroostook Aviation LLC · Millinocket, MEBuilt 1969 · S/N 17258096N79448Thomas William B · Converse, LABuilt 1969 · S/N 17258097N7944BHarms Steven Lee · Cedar Rapids, IABuilt 1957 · S/N 29744N7944GBogardus Peter S · Gouverneur, NYBuilt 1970 · S/N 17259644
Back to AD 90-06-03 R1