AD 86-17-11
Registered aircraft · 359
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:86-17-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-17-11')
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:86-17-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-17-11') 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.
N103GSDuce Phillip N · Kotzebue, AKN10SYBellany Mark A · Freeville, NYN11101Perin Jeffrey S · Wasilla, AKN120AGHallmark Ronald D · Spring Hill, TNN12BEElliott Russell R · Wasilla, AKN141AREpp Robert Jackson · New Kent, VAN143JDHarris Steven V · Springtown, TXN14LMFeuerborn Ethan · Boise, IDN155BHRyan John P · Kankakee, ILN166RWGrasshopper Aviation LLC · Betsy Layne, KYN171GSMccormick Gregory W · Athens, ALN18PRDenicola Frank · Visalia, CAN1900ZChavey Gary G · Manchester, MIN19SDMckenney Bret K · Billings, MTN210BLGraham Mark Allan · Anchorage, AKN21VWSeelye Eric D · Petoskey, MIN221XNapflin Erich P · Wasilla, AKN222ARBrowne Michael · Big Lake, TXN2245ZFoder Troy E · Sunnyside, WAN235DMDouble W Air LLC · Salt Lake City, UTN248HRidge Line Aviation LLC · Denver, CON24QUKepes Bruce R · South Charleston, OHN24WHOption Engineering LLC · Anchorage, AKN274SJList Chad C · Soldotna, AKN280XMorgan Travis L · Eagle River, AKN282XBrekken Chris · Prescott, WIN283XMunhall Alan V · Lakeview, ORN286XKelly John Thomas III · Bells, TXN290XDickson Bernard G · Chiloquin, ORN291XMccown Bobby E · Soldotna, AKN292XStairs Richard B · Fountain, FLN293XEvans Kent L · Mason City, NEN296XHerrema Scott A · White Cloud, MIN2VBParker Grant F · Elgin, ORN302CWWarrington James Whittaker O Jr · Zirconia, NCN304XStone John Brody · Birmingham, ALN305XWallitner Aviation & Restoration LLC · Bremerton, WAN308FDN308fd LLC · Janesville, WIN309XBernacki David A · Clyo, GAN311ECLinton Andrew M · Black Mountain, NCN314XRoss Peter W Trustee · Lufkin, TXN317XBogner Matthew L · Santa Cruz, CAN318XTriple F Flying Inc · Benton, PAN323XLedgerwood Chris · Anchorage, AKN32CXSkowbo Rock · Jacksonville, FLN333BAMartin Nolan T · Anchorage, AKN336XCowan Lance E · Watonga, OKN339XPenland Howard W · Amarillo, TXN343GAN343ga Leasing LLC · Anchorage, AKN346XSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 86-17-11