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.

N557NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10983N5580RN5580r LLC · Summerville, SCBuilt 1965 · S/N 17253179N5580TRedden Joe A · Dawson Springs, KYBuilt 1964 · S/N 17251480N5581RCousins Aviation Inc · Birmingham, MIS/N 17253180N5583TJanke Sean · Gallup, NMBuilt 1964 · S/N 17251483N5584TJellison Michael R · Marysville, WAS/N 17251484N5586RKakkar Sunit · Buena Park, CABuilt 1965 · S/N 17253187N5586TBravo Aviation Services LLC · Jasper, TXBuilt 1964 · S/N 17251486N5587TAnderson Clint V · Clinton, MTBuilt 1964 · S/N 17251487N5588TMoore Robert L · Sublette, KSBuilt 1964 · S/N 17251488N5589RKern Eric M · Wesley Chapel, FLBuilt 1965 · S/N 17253191N558CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13062N558NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10993N5590TGlendening Douglas W · Naples, FLS/N 17251490N5591TNordstrom Terry G · Scottsdale, AZBuilt 1964 · S/N 17251491N5592RAbbott Cedric M · Buckfield, MEBuilt 1965 · S/N 17253196N5593RMaddox Tracey A · Adamsville, TNBuilt 1965 · S/N 17253197N5595EV & E Sunset LLC · St George, UTBuilt 1978 · S/N 17271897N5595RTailwind Enterprises LLC · Edwardsville, ILBuilt 1965 · S/N 17253200N5596RRegistration Pending · Crossville, TNRegistration pendingBuilt 1965 · S/N 17253201N5597ECtj Flyers LLC · Bowdon, GABuilt 1978 · S/N 17271898N5597RStevens Daniel T · Trenton, MOBuilt 1965 · S/N 17253202N5598RCross Brian K · Winters, CABuilt 1965 · S/N 17253204N559SP1.2 Gpa LLC · Rapid City, SDBuilt 2000 · S/N 172S8410N55HAHonaker Group LLC · Sellersburg, INS/N 17269194N55LGWard Randy · Port Saint Lucie, FLS/N 17256728N55LULetourneau University · Longview, TXBuilt 2017 · S/N 172S12063N55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793N55QBSainthill Raymond C · Long Beach, NYS/N 17269080N55SVSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2000 · S/N 172S8488N55YPBmf Jax LLC · Jacksonville, FLS/N F1721930N5600AJessup Modeana M · Wilbur, WABuilt 1956 · S/N 28200N5600RBreland Gerald Monroe Sr · Bogalusa, LABuilt 1965 · S/N 17253207N5601AOsceola Aerosport LLC · Osceola, WIBuilt 1956 · S/N 28201N5602ALooney Hubert · Florissant, MOBuilt 1956 · S/N 28202N5602TBerg William J · Aberdeen, SDS/N 17251502N5603RRegistered aircraftBuilt 1965 · S/N 17253211N5604RSkunda Robert J · Hebron, OHBuilt 1965 · S/N 17253213N5604TAndrews Jeremy R · Walker, MNBuilt 1964 · S/N 17251504N5605AKlase Robert · Greenville, TXS/N 28205N5605JMajor Air LLC · Charleston, SCS/N 17273819N5605RCostello John M · Wichita, KSBuilt 1965 · S/N 17253214N5607AGilbirds William M · Kansas City, MOBuilt 1956 · S/N 28207N5609TWestfall Gage T · Marietta, OKBuilt 1964 · S/N 17251509N560FASteffel Farms LLC · Olivia, MNBuilt 2003 · S/N 172S9560N560THLe Tourneau University · Longview, TXBuilt 2016 · S/N 172S11668N560ZHeslin Jon P · Sutton, MABuilt 1974 · S/N 17262889N5610ANielson Douglas W · East Troy, WIBuilt 1956 · S/N 28210N5611ALewis Christopher Michael · Troy, OHBuilt 1956 · S/N 28211N5611RNordell Louis W · Watervliet, MIBuilt 1965 · S/N 17253222
Back to AD 90-06-03 R1