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.

N5763TLumgair David R · Painter, VABuilt 1964 · S/N 17251663N5764AMorrison Benjamin F III · Godley, TXBuilt 1956 · S/N 28364N5765TRawareo LLC · Warsaw, MOBuilt 1964 · S/N 17251665N5766ASoma Holdings LLC · Wasilla, AKBuilt 1956 · S/N 28366N5766JVan Hoogmoed Andrew P · Turlock, CABuilt 1980 · S/N 17273834N5766TJanson Flying Service Inc · Wadena, MNBuilt 1964 · S/N 17251666N5767RSelf Averill L · Campbell, TXBuilt 1965 · S/N 17253436N5768AGowing Glyn Thomas · Longview, TXBuilt 1956 · S/N 28368N5768RAllenray Corp · Otsego, MIBuilt 1965 · S/N 17253437N5768TCrouse Sheldon · Mount Pleasant, NCBuilt 1964 · S/N 17251668N5769RLatimer Francis E · Washingtonville, NYBuilt 1965 · S/N 17253438N576BWBridgewater State University · North Dartmouth, MAS/N 17280494N576NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10962N576SPSo Cal Leasing LLC · El Cajon, CABuilt 2000 · S/N 172S8501N5770RFurge David T · Brookton, MEBuilt 1965 · S/N 17253439N5771AHunt Jack D · Wilmington, NCBuilt 1956 · S/N 28371N5771RWilson Bach Myrl · Piedmont, SCBuilt 1965 · S/N 17253440N5772ALawlor Stephen M · Saint Joseph, MOBuilt 1956 · S/N 28372N5773AMelton James A · Mayflower, ARBuilt 1956 · S/N 28373N5773REnev Ivan E · Wood Dale, ILS/N 17253442N5774ALoughney Michael L · Indialantic, FLBuilt 1956 · S/N 28374N5774RBallard Thomas L · Seguin, TXBuilt 1965 · S/N 17253443N5775AWeber Francis W Jr · Le Sueur, MNBuilt 1956 · S/N 28375N5776RKatri Thomas L · Conroe, TXBuilt 1965 · S/N 17253445N5776TClark Jeffrey Wayne · Piedmont, MOBuilt 1964 · S/N 17251676N5777RSumner Gary W · Knoxville, TNBuilt 1965 · S/N 17253446N5778TGreen Hornet Aviation LLC · Bloomsburg, PABuilt 1964 · S/N 17251678N5779TArdmore Aviation LLC9667 · Novelty, OHBuilt 1964 · S/N 17251679N577EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13091N577FAN577fa LLC · Redondo Beach, CABuilt 2004 · S/N 172S9577N577FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13079N577NDAir Shares LLC · Casper, WYBuilt 2010 · S/N 172S10986N577SPTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8503N5781RFeauto Aviation Inc · Saint Cloud, FLS/N 17253450N5781TCortis Samuel L · Uniontown, PABuilt 1964 · S/N 17251681N5782JN5782j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273835N5782RSchuck Daniel W · Newark, CABuilt 1965 · S/N 17253451N5782TLas Capital Corp · St Johns, FLBuilt 1964 · S/N 17251682N5783ABright Corner Charter LLC · Bozeman, MTBuilt 1956 · S/N 28383N5783RPritting John R · Reno, NVS/N 17253452N5784AAnderson Steve R · Dillon, COS/N 28384N5785RKablau Frank · Elroy, WIBuilt 1965 · S/N 17253454N5786ABongiorni Robert W Jr · Burgettstown, PABuilt 1956 · S/N 28386N5786RBrown Jeremiah S · Ada, OHS/N 17253455N5786TBam Aviation LLC · Santa Ana, CABuilt 1964 · S/N 17251686N5788AWeston Stetson J · Tremonton, UTBuilt 1956 · S/N 28388N5788THart Justin Owen · Olalla, WAS/N 17251688N5789RShipley Lucas S · Jefferson, IABuilt 1965 · S/N 17253458N578BWBridgewater State University · Bridgewater, MABuilt 1998 · S/N 17280522N578CAChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10807
Back to AD 90-06-03 R1