AD 2001-08-08

Registered aircraft · 5,765

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

N15549Hall Patrick D · Lakeway, TXBuilt 1990 · S/N CE1471N1555LGps Aviation LLC · Kennett, MOBuilt 1988 · S/N E-2419N1555WSmith John Albert Jr · Palm Coast, FLBuilt 1988 · S/N CE-1299N1555YG E C Air LLC · Grove, OKBuilt 1989 · S/N E-2508N1559LLauritzen Clifton · Chowchilla, CAFirst renewal noticeBuilt 1976 · S/N CE-673N155CHK Top J Cattle Company LLC · Eldorado, TXBuilt 1968 · S/N CE-232N155JWTcpb LLC · Lewes, DEBuilt 1975 · S/N D-9837N1560WHigh Performance Aircraft Inc · El Cajon, CABuilt 1997 · S/N E-3097N1561BLamberton Dale F · Brush Prairie, WABuilt 1996 · S/N E-2993N1561GDusky Aviation LLC · Atlanta, GABuilt 1994 · S/N E-2854N1561LRegistered aircraftBuilt 1994 · S/N E-2856N1561MWagner Lacy F · Mission Viejo, CABuilt 1989 · S/N CE-1374N1561TUmanzor Daniel A · S San Fran, CABuilt 1994 · S/N CE-1777N1562BKaplan Steven H Trustee · Santa Barbara, CABuilt 1989 · S/N CE-1362N1562FPatton Janet · Denton, TXBuilt 1994 · S/N E-2857N1563BShulman David A · Frisco, TXBuilt 1994 · S/N CE-1776N1563EZulu Alpha LLC · Naperville, ILBuilt 1989 · S/N E-2473N1563FMcintyre Philip · Monterey, CABuilt 1994 · S/N CE-1782N1563RNovember One LLC · Trophy Club, TXS/N E-2858N1563WArmstrong James L Trustee · Santa Barbara, CABuilt 1972 · S/N D-9370N1564AMcnutt Seth D · Paoli, INBuilt 1989 · S/N CE-1321N1564DAwy LLC · Bentonville, ARBuilt 1994 · S/N E2905N1565WRoad Kill Aviation Inc · Wilmington, DEBuilt 1972 · S/N E-330N1565XCutting Paul P · Wellington, FLBuilt 1994 · S/N E-2853N1566GDuntz David W · Beavercreek, OHBuilt 1989 · S/N CE-1346N1566LRedden Timothy Ray · Citrus Heights, CABuilt 1976 · S/N D-9862N1566PBeech Powers LLC · Henderson, NVBuilt 1988 · S/N CE-1294N1566URegistered aircraftBuilt 1994 · S/N E-2872N1567MPlumbo John T · Port Saint Lucie, FLBuilt 1989 · S/N CE-1407N1567PMy Family Holdings LLC · Greenwood, SCBuilt 1988 · S/N CE-1296N1569PFlying Bull Aviation LLC · Santee, CABuilt 1988 · S/N CE-1300N1570GTurner Michael D · Greenwood, SCBuilt 1989 · S/N E-2512N1570TAcr Holdings LLC · Marysville, OHBuilt 1989 · S/N CE-1365N1571WWest Elk Construction Ltd · Milliken, COBuilt 1972 · S/N D-9349N1576WPowis Michael P · Oak Grove, MOBuilt 1972 · S/N D-9350N1577LKoga 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-826N1579LEvans Christopher A · Lynden, WABuilt 1976 · S/N D-9863N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339N157RDedoming Russell C IV · Boylston, MABuilt 1991 · S/N CE-1636N1581WBrown David C · Overland Park, KSS/N D-9352N1583WNorton William P · Lakeville, MNBuilt 1972 · S/N D-9353N1588Indianhead Aviation LLC · Polk City, IABuilt 1978 · S/N E-1290N1589LCain James W · Big Rapids, MIS/N D-9866N1591WMuraszko Raymond P · Monroe, NJBuilt 1972 · S/N CE-381N1592LLwcr Transportation Inc · Minot, NDBuilt 1976 · S/N E-832N1592WDebonair Flying Club Inc · Medon, TNBuilt 1972 · S/N CE-383N1593LBurr Walter E · Tecumseh, MIBuilt 1976 · S/N CE-637N1594LIntermill Alice R · Volga, SDBuilt 1976 · S/N E-833
Back to AD 2001-08-08