AD 2016-05-13
Registered aircraft · 3,126
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:2016-05-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
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:2016-05-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13') 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.
N602FHFisher Spray Service LLC · Cardington, OHN602GEDeby Ag Leasing Lp · Wakarusa, INFirst renewal noticeN602GKBrekhus Julius Palmer · Kenmare, NDN602GMCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN602HBSilverwings Ag LLC · Burlington, CON602HCKhw LLC · Pioneer, LAN602HFRobinson Reid · Hollis, OKN602HTHendricks Flying Service LLC · Grant, NEN602JBNeal Aircraft Inc · Slaton, TXN602JHAndersons Flying Service Inc · Robbins, CAN602JKKeeter Aerial Spraying Inc · Olney, TXN602JPPrairie Ag Service LLC · Des Arc, ARN602KBGreat Plains Aero Inc · Tolley, NDN602KEDeby Ag Leasing · Wakarusa, INN602KJThompson Flying Service LLC · Charleston, MON602LLD & S Sharp Leasing LLC · Pauls Valley, OKN602LPWillmar Aerial Spraying Inc · Olivia, MNN602MDAgri-Tech Aviation Inc · Indianola, IAN602MHTwin County Air-Ag Inc · Winnie, TXN602MPProbasco Mitchell L · Floydada, TXN602MSLane Aviation Inc · Rosenberg, TXN602MWDekalb Aviation LLC · Williston, NDN602PFShannon Agricultural Flying Inc · Clarksdale, MSN602PKSandpiper Air LLC · Wilmington, DEN602RDRowland Dusters LLC · Raymondville, TXN602REDeby Ag Leasing Lp · Wakarusa, INN602RGGarrett Flying Service Inc · Reeds Spring, MON602SBSparks Brothers Spraying Inc · Gruver, TXN602STL J Leasing LLC · Cardington, OHN602TANeal Aircraft Inc · Slaton, TXN602THCartillar James III · Wynne, ARN602TXBank Of Utah Trustee · Salt Lake City, UTN602WFLake Air Service LLC · Jennings, LAN602WRBi-State Air Inc · Veedersburg, INN602XXBank Of Utah Trustee · Salt Lake City, UTN602YAYuma Ag Air LLC · Yuma, CON6034CNeal Aircraft Inc · Slaton, TXN60362502 Leasing LLC · Waupun, WIN6039SKorn Bruce N Jr · Grandfield, OKN603HPLease Air Inc · Dalhart, TXN603MPNeal Aircraft Inc · Slaton, TXN603RHCat Agri Aviation · Paragould, ARN603WAN728ds LLC · Yakima, WAN6042SEdwards Flying Service Inc · Leland, MSN60446Last Pass Aviation Inc · Humboldt, IAN60482Blue Earth Flying Service LLC · Blue Earth, MNN604MGGary Flying Service Inc · Inverness, MSFirst renewal noticeN604MPSeewald Jeffrey W · Great Bend, KSN60561Wbd Flying LLC · Sondheimer, LAN605DKBravo Gildardo F · Mission, TX
Back to AD 2016-05-13