AD 2011-01-52
Registered aircraft · 416
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:2011-01-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52')
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:2011-01-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52') 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.
N262LHNeo Helicopter Academy LLC · North Royalton, OHN267RWKoelzer Galen G · Othello, WAN269AReynolds Darryl G · Wills Point, TXN269ABSkyline Aviation Inc · San Angelo, TXN269ADU S Aviation Training Solutions Inc · Titusville, FLN269AHUS Aviation Training Solutions Inc · Titusville, FLN269AJSkyline Aviation Inc · San Angelo, TXN269CNN9660f LLC · Grand Ledge, MIN269GLAerospace Trust Management LLC Trustee · Wilmington, DEN269HVertical Development LLC · Birmingham, ALN269HAN269ha LLC · Manassas, VAN269HHCaprock Technical Services Inc · Kempner, TXN269JATeam Aero LLC · Shawnee, KSN269JPBrones Jon P · Blanco, TXN269MDCactus Air Force LLC · Carson City, NVN269MRAgl LLC · Othello, WAN269NInternational Air Services Inc Trustee · Carson City, NVN269SFHarvey Kandace · Snohomish, WAN269SRRaper David A · Mesa, AZN269STSalina Tree Inc · Salina, KSN269TCRegistration Pending · Redmond, WARegistration pending, pending cancellationN269TJSenninger Thomas P · Clermont, FLN269TPPhoenix Leasing LLC · Menomonee Falls, WIN269TTSharmark LLC · Dry Ridge, KYN269VCRegistered aircraftN269VTQualitair LLC Trustee · MichelstadtN271DGMa King LLC · Stanwood, WAN279SAAll On Black LLC · New Smyrna Beach, FLN292BHelo Operations LLC · Waynesville, MON296CPatriot Marine LLC · New Haven, CTN29PJCastle Farms Inc · Sunnyside, WAN300ARAw Industries LLC · Comanche, TXN300AUSchweizer Rsg LLC · Fort Worth, TXN300BPOpie Aviation Services LLC · Nashville, NCN300DSEllis Thomas Troy · Slidell, LAN300GUSchewizer Rsg LLC · Fort Worth, TXN300NBMcilrath Thor · Arlington, WAN301DTDawson Taylor Enterprises LLC · Dover, DEN301MGWild Blake · Waialua, HIN302HGHarding William Jr · Quinlan, TXN303HGWhirlybirds LLC · Mount Pleasant, SCN305BSAllen Andra L · Gila, NMN3075UEvans Ronald G · Imlay City, MIN308CWHeritage Investment Corp · Arlington, TXN310CPOregon Heli LLC · Bandon, ORN311GBWhirlygig Enterprises LLC · Dover, DEN322CPPaul William D · Cadillac, MIN330JBHavens Aviation LLC · Blacklick, OHN330PDCity Of Oakland · Oakland, CAN333GJOliver Enterprises LLC · Newalla, OK
Back to AD 2011-01-52