Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N9787YMaeda Shinji · Mill Creek, WABuilt 1963 · S/N D-7235 N9788LKluge Andrew J · Colorado Springs, COBuilt 1972 · S/N MC-116 N9788YRichards Fletcher D III · Longmont, COBuilt 1963 · S/N D-7163 N9789LGraham Michael · Fayetteville, GABuilt 1973 · S/N MC-115 N9789RBorth Christian D · Alameda, CABuilt 1960 · S/N D-6301 N9789YParsons John C · Wichita, KSBuilt 1963 · S/N D-7164 N978BBank Of Utah Trustee · Salt Lake City, UTBuilt 1961 · S/N DH-314 N978GKFox Whiskey Inc · Wilmington, DEBuilt 1996 · S/N E-3047 N978JGColorado Orthopaedic Outreach Inc · Steamboat Springs, COS/N EA-637 N9790RRorke David E · Benicia, CABuilt 1961 · S/N D-6320 N9791RBlaskovich Thomas M · Highland, CABuilt 1960 · S/N D-6289 N9794YNistico/Weisbart Patricia Ann · Carbondale, COBuilt 1963 · S/N D-7169 N9795RDevins Frederick G · Sussex, NJBuilt 1960 · S/N D-6308 N9795YRick Grossmann & Associates LLC · Overland Park, KSBuilt 1963 · S/N D-7170 N9796RMeadowlake Airpark LLC · Lenoir City, TNBuilt 1960 · S/N D-6327 N9797RGrave Eugene G · Spencer, INBuilt 1960 · S/N D-6334 N9797YPlane Services LLC · Twin Falls, IDBuilt 1963 · S/N D-7286 N9798RMarine Aviation Museum Inc · Wilmington, DEBuilt 1960 · S/N D-6330 N9799RBergen Daniel Michael Jr · Millersville, MDS/N D-6345 N979ABCartwright Jeffry D · Cabool, MOBuilt 1963 · S/N D-7143 N979DMStarnes James W · Beaufort, SCBuilt 1978 · S/N TE-1132 N979MAMeisner Aircraft Inc · Burlington, WIBuilt 1978 · S/N E-1294 N97AHKw Air LLC · Fallbrook, CABuilt 1980 · S/N EA-107 N97BJRegistration Pending · Dublin, TXRegistration pendingBuilt 1966 · S/N D-8218 N97BKA&D Machinery LLC · Hartsville, SCBuilt 1996 · S/N E-3064 N97BWDillard Wendell H · Centerville, TXBuilt 1963 · S/N TC-407 N97GWLeft Coast Transport LLC · Largo, FLBuilt 1977 · S/N E-1143 N97LSFly2golf LLC · Largo, FLS/N TC-899 N97RTeh LLC · Mccall, IDBuilt 1977 · S/N TK-45 N97RGArmy Aviation Heritage Foundation · Hampton, GAS/N TF-20 N97VCSababa Aviation LLC · West Palm Beach, FLBuilt 1985 · S/N TJ-495 N97WBBowditch Harold W Jr · Lancaster, PABuilt 1967 · S/N D-8386 N97WSPrestige Worldwide Enterprises LLC · Germantown, TNBuilt 1979 · S/N E-1433 N9801RMaradei Jefferson V · Mcallen, TXS/N D-6335 N9802RSchutes John T · Brimfield, MABuilt 1960 · S/N D-6314 N9804RCentral Coast LLC · Olympia, WABuilt 1960 · S/N D-6311 N9805RYoder Daniel L · Pond Creek, OKS/N D-6333 N9806RGifford Brent D · Elk City, OKBuilt 1960 · S/N D-6312 N9808RI M Foxbo LLC · Wilmington, DEBuilt 1960 · S/N D-6316 N9809RJimmy Michael Fletcher · Wausa, NES/N D-6460 N980DRJessen Dennis H · Pequot Lakes, MNBuilt 1960 · S/N D-6338 N980QMartinez Marcus · Dana Point, CABuilt 1961 · S/N D-6852 N980SEKfg Aviation Inc · Huntersville, NCS/N D5580 N9810RMccreary William B · Turnersville, NJFirst renewal noticeBuilt 1960 · S/N D-6385 N9814RMankins Kristina · Paso Robles, CABuilt 1960 · S/N D-6325 N9816RV Tail Flyers Group LLC · Deland, FLBuilt 1960 · S/N D-6318 N9817RRegistration Pending · Simms, MTRegistration pendingBuilt 1960 · S/N D-6370 N9818RDurkee Michael S · Amelia, OHBuilt 1960 · S/N D-6323 N981YLavallee David A · Uxbridge, MABuilt 1967 · S/N D-8503 N9821RBender Josh · El Reno, OKBuilt 1960 · S/N D-6355

Back to AD 99-05-13 R1 WD