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.
N802BHMoes Crop Dusting Service Inc · Marysville, CAN802BKKlein Flying Service Inc · Lawrenceville, ILN802BLLindeman Inc · Dhanis, TXN802BMEvergreen Flying Service Inc · Rayville, LAN802BRAir Kraft Spraying Inc · Timber Lake, SDN802BWBoedeker Flying Service West LLC · Childress, TXN802CBR & W Flying Inc · Paragould, ARN802CLKansas Farm And Ranch Inc · Seneca, KSN802CRMeyer Bros Ag LLC DBA · Algona, IAN802CWAurora Cooperative Elevator Company · Aurora, NEN802DFDungan Aerial Service Inc · Falmouth, INN802DJKansas Farm And Ranch Inc · Seneca, KSN802DKKroeplin Air LLC · Highmore, SDN802DMRice Flying LLC · Poplar Bluff, MON802DRAgri Air Industries Of Arkansas LLC · Paragould, ARN802DTThiel Air Care Inc · Chowchilla, CAN802DVMcgarity Flying Service LLC · Sikeston, MON802EAdams Aerial Solutions LLC · Decatur, ILN802EBDakota Air Spray LLC · Huron, SDN802EGEagle Lake Leasing LLC · Bradford, ARN802EMMeyerkorth Aviation LLC · Rock Port, MON802ETMid-State Aviation II Inc · Cozad, NEN802FFoxtrot Air LLC · Highmore, SDN802FFFlight Level Zero LLC · Othello, WAN802FUFlight Level Zero LLC · Othello, WAN802FYSlikker Flying Service Inc · Buttonwillow, CAN802FZBoardman Air Service LLC · Henderson, NEN802GB&D Aircraft Leasing LLC · Waupun, WIN802GBG B Aerial Applications Inc · Slaton, TXN802GEDeby Ag Leasing · Wakarusa, INN802GKKurtz Rural Aviation LLC · Mound City, MON802HAPontiac Flying LLC · Pontiac, ILN802HBKansas Farm And Ranch Inc · Seneca, KSN802HCSouthern Aerial Service LLC · Douglas, GAFirst renewal noticeN802HFBank Of Utah Trustee · Salt Lake City, UTN802HJAir Support 1 Inc · Middletown, DEN802HMAero S E A T Inc · Sterling, CON802HPMidwest Agri Drone LLC · Saint Joseph, MON802HRAg Concepts Inc · Morgan City, MSN802HSSecurity Holdings LLC · Richmond, VAN802HXHartley Flying Service Inc · Stuttgart, ARN802JCrop Jet Aviation LLC · Gooding, IDN802JCRba LLC · Kimberly, IDN802JEBank Of Utah Trustee · Salt Lake City, UTN802JFMiles Flying Service Inc · Bono, ARFirst renewal noticeN802JGFirst State Ag Air Inc · Viola, DEN802JHRanch Aero LLC · Sterling City, TXN802JJSummer Agro Services LLC · Royal Palm Beach, FLN802JLBravo Ag Air LLC · Belmond, IAN802JTPonderosa Airtankers LLC · Safford, AZ
Back to AD 2016-05-13