AD 2003-01-01

Registered aircraft · 3,862

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:2003-01-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-01-01')
  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.

N1648WKings Aviation Corp · Garden City, NYBuilt 1972 · S/N TH-251N1650WGriffin Michael D · Madison, ALBuilt 1972 · S/N E-352N165HPKessler William A Jr · Uvalde, TXBuilt 1981 · S/N E-1856N165JVHigh Desert Aviation And Aerobatics LLC · Pocatello, IDBuilt 1998 · S/N E-3180N166BVSensing Aviation LLC · Nashville, TNBuilt 2000 · S/N TH-1958N1673THarvey Alan G · Dallas, TXBuilt 1981 · S/N E-1895N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849N1687WAirway Management Inc · Wilmington, DEBuilt 1972 · S/N E-355N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606N168JGFlymore LLC · New City, NYBuilt 1999 · S/N E-3253N1694WKlauber James S Sr · Boonsboro, MDBuilt 1972 · S/N E-363N1697WMountcastle Creek LLC · Pratt, KSBuilt 1972 · S/N E-365N1699WDkp Holdings LLC · Melbourne Beach, FLBuilt 1973 · S/N E-399N169GRBlue Skies Above LLC · Spring, TXBuilt 1995 · S/N EA-580N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999N169TGNordic Sun LLC · Garner, NCBuilt 2005 · S/N E-3627N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501N16EJAlphaalpha Aviation LLC · Paragould, ARS/N E-3507N16NHRutgers Nicholas G IV · Camas, WABuilt 1985 · S/N E-2220N16PMcmurray Justin John · Durham, NCBuilt 1999 · S/N TH-1925N1706WHinton Bay Management LLC · Jackson, WYBuilt 1972 · S/N E-366N1707WRussell Marc R · Simi Valley, CABuilt 1972 · S/N E-367N171CEGarrison Randy · Queen City, TXBuilt 1973 · S/N E-504N171DDNorfolk Aircraft Interiors LLC · Virginia Beach, VAS/N E-108N171PBHarding Derrick S DBA · Adair, OKBuilt 1995 · S/N E2992N171PFRegistration Pending · Los Osos, CARegistration pendingBuilt 1980 · S/N EA-164N1731WCollins Air LLC · Kennett, MOBuilt 1972 · S/N E-369N174TATracewings LLC · Goodyear, AZS/N E-3499N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73N17509Starke Charles H III · Weirsdale, FLBuilt 1976 · S/N E-972N17520Patterson William · Spring, TXBuilt 1976 · S/N E-974N1752WMichael S Austin Dmd Ms Psc · Utica, KYBuilt 1972 · S/N E-373N1755WAis Construction Equip Corp · Grand Rapids, MIBuilt 1972 · S/N E-374N17571De Oliveira Derek · Meadow Vista, CABuilt 1977 · S/N E-983N175LKern Charter Service Inc · Bakersfield, CABuilt 1977 · S/N E-985N17621Boe Mark · Morgan, UTBuilt 1977 · S/N E-992N17628Elliot Air LLC · Dunwoody, GABuilt 1977 · S/N E-993N17639Peterson Eric S · San Jose, CABuilt 1977 · S/N E-997N1763W63 Whiskey LLC · Seattle, WABuilt 1973 · S/N E-406N17653Coggin Randall · Longview, TXBuilt 1977 · S/N E-998N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810N17668Broadway Travis A · Alexandria, LABuilt 1977 · S/N E-1001N17669Srg Enterprises LLC · Montgomery, ALBuilt 1977 · S/N E-1002N17698Spindel Stuart H · Hawesville, KYBuilt 1977 · S/N E-1005N176DRKelly Daniel · Alpharetta, GAS/N E-3592N176LFFour Basics LLC · Olathe, KSBuilt 1977 · S/N E-1052N176STCp A36 Inc · Knoxville, TNBuilt 1976 · S/N E-884N176WHarwell Evin Dtrustee · Howell, MIBuilt 1978 · S/N E-1335N176XClub Turbo 176 LLC · Santa Clara, CABuilt 1976 · S/N E868
Back to AD 2003-01-01