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.

N1564LWhipple Cory · Senatobia, MSBuilt 1976 · S/N TK-6N1564RKm Unlimited LLC · Fallbrook, CABuilt 1988 · S/N EA-487N1565WRoad Kill Aviation Inc · Wilmington, DEBuilt 1972 · S/N E-330N1565XCutting Paul P · Wellington, FLBuilt 1994 · S/N E-2853N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549N1566URegistered aircraftBuilt 1994 · S/N E-2872N1566W66 Whiskey LLC · Atlanta, GABuilt 1994 · S/N TH-1713N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542N1570GTurner Michael D · Greenwood, SCBuilt 1989 · S/N E-2512N1570NUp N Down Adventures LLC · Calera, OKBuilt 1994 · S/N TH-1715N1577LKoga Corp Inc · Las Vegas, NVS/N E-825N1577WDshannon Products Ltdregistered · Buffalo, MNBuilt 1972 · S/N E-333N1578LBaloian Packing Co Inc · Fresno, CABuilt 1976 · S/N E-826N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339N157JRSoft Landings LLC · Myrtle Beach, SCBuilt 1991 · S/N TH-1639N1588Indianhead Aviation LLC · Polk City, IABuilt 1978 · S/N E-1290N158BBStubbs J Phillip · Richmond, VABuilt 1975 · S/N TH-592N158BDJ L Aviation LLC · Jonesboro, ARBuilt 1979 · S/N TH-1045N158BHB58 LLC · Granger, INBuilt 1988 · S/N TH-1540N158BJPerfectus Inc · Wilmington, DES/N TH-324N158BMChorman Spraying LLC · Milton, DEBuilt 1981 · S/N TH-1244N158KPelican Aviation Inc · Gainesville, GABuilt 1980 · S/N TH-1178N158NRoss Adam · Texarkana, TXBuilt 1981 · S/N EA-197N158NCIal Corp · Lewes, DEBuilt 1974 · S/N TH-444N158PA2 Laikas LLC · Helena, MTBuilt 1978 · S/N TJ-141N158RFBeech Bound LLC · Morgantown, WVBuilt 1978 · S/N TH-941N158RMWings Lc · Baltimore, MDBuilt 1988 · S/N TH-1543N158SWFern Leasing Corp · Larkspur, CABuilt 1999 · S/N TH-1921N158TBLunt Christopher K · Marco Island, FLBuilt 1977 · S/N TH-826N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008N1592LLwcr Transportation Inc · Minot, NDBuilt 1976 · S/N E-832N1594LIntermill Alice R · Volga, SDBuilt 1976 · S/N E-833N1598TRegistered aircraftBuilt 1981 · S/N EA-263N159AARegistered aircraftBuilt 1975 · S/N E-765N159SMMcneill Transportation LLC · Whiteville, NCS/N TH-2085N15DNSnowflake Aircraft LLC · Fayetteville, NYBuilt 1989 · S/N E-2472N15GMBristol Aviation De LLC · Wilmington, DEBuilt 1995 · S/N E2977N15PMDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N E-1016N15RDWood Richard W Trustee · Oroville, CABuilt 1978 · S/N E-1407N15RPKnob Creek Aviation LLC · Oak Ridge, LABuilt 1974 · S/N E-539N15XAMenigoz Michael Steven · Puyallup, WABuilt 1975 · S/N E-732N1604MMckinney John Merrill Jr · Bessemer, ALBuilt 1983 · S/N TH1359N1604WSteve Byrd Aviation LLC · Terrell, TXBuilt 1972 · S/N TH-242N161KCCk Aviation LLC · Melbourne, ARBuilt 1980 · S/N E-1700N161TSDoege Jackson B · Dallas, TXS/N E-3519N1629WRegistered aircraftN-number assigned, not yet registeredS/N TH-245N162BLMid South Aviation Inc · New Orleans, LAS/N E-2263N1635WTullos Hugh S III · Oklahoma City, OKBuilt 1972 · S/N E-350N163UHarbaugh Steven K · Austin, TXBuilt 1968 · S/N E-98
Back to AD 2003-01-01