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.

N11YPDanforth Equipment LLC · Leesburg, FLBuilt 1987 · S/N TH-1509N120DBB & I Leasing LLC · Berryville, VABuilt 1978 · S/N E1276N120WTZulu Time LLC · Park City, UTBuilt 1980 · S/N EA-99N1212GNickeson Family LLC · Maquoketa, IABuilt 1988 · S/N E-2418N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254N121PEEggers Phillip S · Denton, TXBuilt 1983 · S/N EA-388N121YPNine Five Alpha LLC · Huntsville, ALBuilt 2000 · S/N E-3359N1228PPapa Aviation LLC · Chicago, ILBuilt 1990 · S/N E-2577N122CERay Kevin T · Columbus, TXBuilt 1979 · S/N E-1475N122GTSperr Adam C · Donnelly, MNBuilt 1980 · S/N E-1673N122LGStewart John H · Burlington, COBuilt 1988 · S/N E-2413N122RMHolland Mark Drew · San Antonio, TXBuilt 1984 · S/N TH-1416N1230ZC & J Air Inc · Middleton, DEBuilt 1994 · S/N E-2875N1234QDembowski Rodrick · Seattle, WABuilt 1969 · S/N E-165N123AVGc 43 LLC · Annandale, VAS/N E-319N123AZN123az LLC · Las Vegas, NVS/N EA-498N123GSLou Ann Inc · Los Altos, CABuilt 1979 · S/N E-1464N123MMMuller Miles O · Staples, TXBuilt 1986 · S/N E-2332N123TWGrandy Boyd · Smoot, WYBuilt 1974 · S/N E-518N123USLow Gary Mike · Southside, ARBuilt 1982 · S/N TH-1335N123WBHighview LLC · Brentwood, TNBuilt 1978 · S/N TH-937N124LCBucks Air Charters Inc · Wilmington, DEBuilt 1980 · S/N E-1684N124TJAlan Aviation LLC · Los Angeles, CAS/N TH-923N125ARJuliet Kilo Air 1 LLC · Paradise Valley, AZBuilt 1980 · S/N EA-169N125BEGomez Eliud · Winter Park, FLS/N TH-43N126GLN126gl LLC · Roca, NEBuilt 1975 · S/N E-763N128AEChiave Solutions LLC · Orlando, FLBuilt 1981 · S/N E-1830N128WMOac Aviation LLC · Asheville, NCBuilt 1997 · S/N E3115N128WSSkyway Air Taxi LLC · Manassas, VABuilt 2001 · S/N TH-1982N129ABPhilly Express LLC · Wilmington, DEBuilt 1994 · S/N EA-561N129BMMain Gary Michael · Haverford, PABuilt 2004 · S/N E-3588N129RJKenney Donill · Lake Worth, FLBuilt 1980 · S/N E-1752N129TRDawson Aircraft Inc · Clinton, ARBuilt 1994 · S/N E-2888N12BTexacali Air LLC · Salado, TXBuilt 2001 · S/N E-3392N12FGEchols Mill Aviation LLC · Elberton, GABuilt 1998 · S/N E-3219N1313WSecond Kitchen LLC · Chicago, ILBuilt 1979 · S/N E-1440N1316RAirgo Partners LLC · Lititz, PABuilt 1968 · S/N E-125N132FBRock Rivers Bancorp · Rock Rapids, IABuilt 1975 · S/N E-700N133EMWheels Up LLC · Lincoln, NES/N E-517N1350SLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1976 · S/N TH868N1351RN1351r Inc · Middletown, DEBuilt 1979 · S/N EA-21N135FBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N TH816N136AAEllis Robert W · Cresson, TXBuilt 1985 · S/N E2229N136AFMorley John A · Tewksbury, MABuilt 1981 · S/N E1861N136AMButler Aviation Llp · Smyrna, TNBuilt 1991 · S/N E2641N136BSmith Richard M · Newton, MSBuilt 1973 · S/N E-390N136BEHeavy D Airways LLC · Fountain Hills, AZBuilt 1992 · S/N EA-541N136BFEisenhart Dwight · Clinton, ARBuilt 1987 · S/N EA-465N136CDSnow Jason D · West Lafayette, INBuilt 1977 · S/N E-1162N136CMTriple C Inc · Carlsbad, NMS/N EA-437
Back to AD 2003-01-01