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.

N9145QWest Thomas P Jr · Bridgeport, OHBuilt 1971 · S/N TE-834 N9145SJuhl Christian B · Boynton Beach, FLBuilt 1976 · S/N M-1768 N9148SBlue Skies Aviation LLC · Holland, MIS/N MB-787 N914BSSchwartzman Blake R · Las Vegas, NVBuilt 1991 · S/N CE-1579 N914GPRoy Dino · Saginaw, TXBuilt 1966 · S/N MA-124 N914THanley Stuart · Hollywood, FLBuilt 1960 · S/N TD-347 N9152SHomer Mark · Grosse Ile, MIBuilt 1975 · S/N MC-399 N9153QHansing Frederick Christopher · Moorpark, CABuilt 1970 · S/N D-9239 N9153SB Squared Inc · Bedford, NHBuilt 1976 · S/N MC-400 N9154QBuck Air LLC · Dover, DEBuilt 1971 · S/N CE-318 N9155QPeters William B · Vienna, WVBuilt 1970 · S/N CE-319 N9156SStickley Harold R · Wauseon, OHBuilt 1976 · S/N MC-401 N9158QBurton John H III · Woodstock, ILBuilt 1970 · S/N D-9217 N915VThomas Robert W · Henderson, NVFirst renewal noticeBuilt 1974 · S/N TC-1785 N9161SCarr Jack Willson · East Lansing, MIBuilt 1975 · S/N MB-785 N9163SRegistration Pending · Frederick, MDRegistration pendingBuilt 1976 · S/N M-1778 N9164NDangberg Dennis · Wayne, NEBuilt 1964 · S/N TC-574 N9164QFletcher Mountain Aviation LLC · Hampden, MEBuilt 1971 · S/N CE-323 N9164SGreat Planes Flyers LLC · Mccook, NEBuilt 1976 · S/N MC-403 N9165SHufford Christopher · Tucson, AZBuilt 1976 · S/N M-1779 N9166SHarris Douglas H · Morgan, UTBuilt 1976 · S/N M-1780 N9167SContinental Aviation Club Inc · Lincoln, VABuilt 1976 · S/N M-1781 N9169HShackelford John S Jr · Roanoke, TXBuilt 1947 · S/N 6879 N9169QCloudcap LLC · Smithville, TNBuilt 1970 · S/N E-253 N916BCN916bc LLC · Woodward, OKBuilt 1988 · S/N E-2448 N916JWSouth Delta Aviation Inc · Fayetteville, ARBuilt 1976 · S/N TJ-91 N916MTSchumacher Charles · Cambridge, MABuilt 1973 · S/N TC-1623 N916QWeis John F · Sedona, AZBuilt 1961 · S/N D-6810 N916RCDw Aviation LLC · San Diego, CABuilt 1966 · S/N D-8326 N9170QKing Air Properties LLC · Huntington Beach, CABuilt 1971 · S/N CE-327 N9170SLee Benjamin W Trustee · Chandler, AZBuilt 1976 · S/N M-1783 N9171QBeech Babe Ltd · Colorado Springs, COBuilt 1970 · S/N D-9246 N9172SShuffield Brian D · Oregon House, CAS/N M-1793 N9177QPapst Bonanza LLC · Parker, AZBuilt 1970 · S/N E-257 N9177SNabeth Jeremy S · Austin, TXBuilt 1976 · S/N M-1789 N9177ZShine Transportation Leasing LLC · Winchester, VABuilt 1979 · S/N CE-853 N9178SSwoboda Kristin · Boise, IDBuilt 1976 · S/N MC-406 N9179QDewitt Weldone · Brashear, TXBuilt 1971 · S/N CE-331 N9179SCharles Clarens · Brooklyn, NYBuilt 1976 · S/N M-1800 N9179XJohnson Randolph B · Wichita Falls, TXBuilt 1992 · S/N E2759 N917DCRegistered aircraftFirst renewal noticeBuilt 1981 · S/N E-1884 N917JKJen-Kel Aviation LLC · Sarasota, FLBuilt 1975 · S/N E-652 N917SDTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9988 N9181QWhitfield Timothy D · Fairfield, NCBuilt 1970 · S/N TC-1381 N9181SFhs Aero Co Ltd · Olathe, KSBuilt 1976 · S/N M-1798 N9182SBig Bend Community College · Moses Lake, WABuilt 1975 · S/N MB-786 N9183BSteller Aviation LLC · Middletown, DEBuilt 1991 · S/N E-2631 N9183SToole William Barry · Goochland, VABuilt 1976 · S/N M-1802 N9185SGrushkin Jon S · Mazon, ILBuilt 1976 · S/N M-1799 N9186QGaines Norse · Irvine, CABuilt 1971 · S/N CE-332

Back to AD 99-05-13 R1 WD