OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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

N1563FMcintyre 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 E2905N1564RKm Unlimited LLC · Fallbrook, CABuilt 1988 · S/N EA-487N1564SRegistered aircraftBuilt 1962 · S/N TC-313N1565WRoad Kill Aviation Inc · Wilmington, DEBuilt 1972 · S/N E-330N1565XCutting Paul P · Wellington, FLBuilt 1994 · S/N E-2853N1565ZStowe Martin D · Carlsbad, CABuilt 1961 · S/N D-6867N1566GDuntz 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-2872N1567AKarsten Steven R · San Juan Capo, CABuilt 1969 · S/N TC-1270N1567MPlumbo John T · Port Saint Lucie, FLBuilt 1989 · S/N CE-1407N1567PMy Family Holdings LLC · Greenwood, SCBuilt 1988 · S/N CE-1296N1567SWegener Properties LLC Series Bonanza · Aurora, ILBuilt 1962 · S/N D-6993N1568ZKeenan Michael Richard Sr · Albuquerque, NMBuilt 1961 · S/N D-6870N1569LRegistered aircraftBuilt 1976 · S/N TC-1945N1569PFlying Bull Aviation LLC · Santee, CABuilt 1988 · S/N CE-1300N156ASkymook Aviation LLC · Beaver Falls, PABuilt 1977 · S/N TK-56N156ASWallwork Robert R III · Wauna, WABuilt 1976 · S/N MB-805N1570GTurner Michael D · Greenwood, SCBuilt 1989 · S/N E-2512N1570RHall Clarence W Jr · Fayetteville, ARS/N M-1368N1570TAcr Holdings LLC · Marysville, OHBuilt 1989 · S/N CE-1365N1570ZSalvay Michael E · Long Beach, CABuilt 1961 · S/N D-6872N1571WWest Elk Construction Ltd · Milliken, COBuilt 1972 · S/N D-9349N1572LDavids Burgers Park Plaza Corp · North Little Rock, ARBuilt 1976 · S/N TC-1946N1576WPowis Michael P · Oak Grove, MOBuilt 1972 · S/N D-9350N1576ZOzarks Auto Show Inc · Hollister, MOBuilt 1961 · S/N TC-221N1577LKoga Corp Inc · Las Vegas, NVS/N E-825N1577SSanders Aviation Inc · Jasper, ALBuilt 1962 · S/N TD-513N1577WDshannon Products Ltdregistered · Buffalo, MNBuilt 1972 · S/N E-333N1577ZAthuil Philippe · Beverly Hills, CABuilt 1961 · S/N D-6878N1578LBaloian Packing Co Inc · Fresno, CABuilt 1976 · S/N E-826N1578ZProctor Brian S · Leesburg, TXBuilt 1961 · S/N D-6877N1579LEvans Christopher A · Lynden, WABuilt 1976 · S/N D-9863N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339N157FBeech Cristina I · Lake Mary, FLBuilt 1954 · S/N D-3934N157JTWest Pacific Air LLC · Spokane, WABuilt 1982 · S/N P-589N157NNewsome Jeffrey S · Blackwell, OKBuilt 1976 · S/N TJ-52N157RDedoming Russell C IV · Boylston, MABuilt 1991 · S/N CE-1636N157ZLBrooks Aviation Inc · Douglas, GAS/N BG-355N1580ZLiebmann Christopher J · Tehachapi, CABuilt 1961 · S/N D-6879N15815James Roger L · New Carlisle, OHBuilt 1936 · S/N B17R-70N1581WBrown David C · Overland Park, KSS/N D-9352N1582ZAugust Aero LLC · Kalispell, MTBuilt 1961 · S/N D-6880N15835Pederson William K · Hillsboro, ORBuilt 1936 · S/N 74N1583WNorton William P · Lakeville, MNBuilt 1972 · S/N D-9353
Back to AD 99-05-13 R1 WD