OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,678

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.

N117WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276264N11802N11802 LLC · Bradenton, FLBuilt 2007 · S/N 172S10463N1180MFlying Weaners Inc · Jacksonville, FLBuilt 1969 · S/N 17258680N1180NWinkelmann Aerospace LLC · Malabar, FLBuilt 2007 · S/N 172S10461N1180UAom Aircraft LLC · Wilmington, DES/N 17266881N1181MChin David · San Jose, CABuilt 1969 · S/N 17258681N1181U404 Ltd · Pulaski, WIBuilt 1976 · S/N 17266882N1182MHilton David T · Brooksville, FLBuilt 1969 · S/N 17258682N1182UGreen Rebecca · Colchester, CTBuilt 1976 · S/N 17266883N1183FHopfinger Carl J · Pittsford, NYBuilt 1966 · S/N 17254778N1184FSkydotcom LLC · Inver Grove Hghts, MNBuilt 1966 · S/N 17254779N1185FClements Michael R · Gig Harbor, WABuilt 1979 · S/N 17272963N1185MOwen Steve · White City, ORBuilt 1969 · S/N 17258685N1186FLaclef Zebulon S · Leon, KSBuilt 1966 · S/N 17254781N1187MMorgan Donald F · Reno, NVBuilt 1970 · S/N 17258687N1187UNiderost Greg · Ukiah, CABuilt 1976 · S/N 17266888N1188FHumphrey Rex B · Bonney Lake, WABuilt 1966 · S/N 17254783N1188LAyah Investments LLC · Kent, WABuilt 2006 · S/N 172S10370N1188MTrim Tab LLC · Fort Collins, COBuilt 1969 · S/N 17258688N1188UAurotel Aviation Inc Trustee · Wilmington, DEBuilt 1976 · S/N 17266889N118ETL & W Leasing LLC · Smyrna, TNBuilt 1997 · S/N 17280019N118FSTfs Air LLC · Loveland, COBuilt 2003 · S/N 17281198N118KSKent State University · Stow, OHBuilt 1999 · S/N 17280822N118PCCarenbauer Paul J · Hernando, FLBuilt 1976 · S/N 17268427N118SVChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S10102N1190FDonnelly Patrick J · Tupper Lake, NYBuilt 1966 · S/N 17254785N1190MDorr Daniel B · Locust Grove, GABuilt 1969 · S/N 17258690N1191FStopa Gary · Florida, NYBuilt 1966 · S/N 17254786N1191MMoore John S · Tracy, CABuilt 1969 · S/N 17258691N1191UFlitepro Inc · Murrieta, CAS/N 17266892N1192MGaruda Aviation Inc · Miami, FLBuilt 1969 · S/N 17258692N1193FVoss Douglas D · Grand Island, NEBuilt 1979 · S/N 17272964N1193MEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17258693N1194MGadamic LLC · Fresno, CABuilt 1969 · S/N 17258694N1195UMatonti James R · Oklahoma City, OKBuilt 1976 · S/N 17266896N1196MAtlas Aviation LLC · Buckhannon, WVS/N 172S10424N1196USwaff Properties LLC · Humble, TXBuilt 1976 · S/N 17266897N1197UP D H S Aerial Photography Inc · St Petersburg, FLBuilt 1976 · S/N 17266898N1198FStockle Barry W · Oakland, CABuilt 1966 · S/N 17254793N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698N1199DSpacely Space Sprockets LLC · Aurora, ORBuilt 2006 · S/N 172S10388N1199HWingsleasing LLC · Wichita, KSBuilt 2006 · S/N 172S10390N119DCDuque Helen · Orlando, FLS/N 17267722N119DHJohnson Peter L · Chico, CAS/N 36257N119FRJeffery & Weiss Holdings LLC · Long Beach, CAS/N 17276535N119KSKent State University · Stow, OHBuilt 1999 · S/N 17280823N119P4dw Interests LLC · Longview, TXS/N 17263873N119PWMeyer Peter W · Stevensville, MDBuilt 1999 · S/N 172S8127N119SJetkinect LLC · Henderson, NVBuilt 2000 · S/N 172S8402N11KTHilborn Rebecca M · Addison, NYBuilt 1956 · S/N 28593
Back to AD 90-06-03 R1