AD 2012-10-52
Registered aircraft · 2,750
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N29190Mountain Helicopters LLC · Salt Lake City, UTN291MWHeritage Aviation Management Ltd · Conroe, TXN29210Hawkes Brian R · Hamilton, MTN29542Giannakakis Peter J · Monroe, MIN295CSLarsen Levitation LLC · Wasilla, AKN295FAStationair Amphib LLC · Jefferson City, MON29631Registered aircraftN29674Snflk Leasing LLC · Andrews, TXN296CS1928 LLC · Salmon, IDN296DEDouble T Flyers LLC · Fort Worth, TXN296FSD7 Roofing LLC · New Baden, ILN296PBChurch Aviation LLC · Christmas Valley, ORN297BCUnderwood David · Sarasota, FLFirst renewal noticeN297CMHeritage Aviation Management Ltd · Conroe, TXN297DRMingus Mason · Scottsville, KYN297ZEnovi LLC · Las Vegas, NVN298PN206 Cat Air LLC · Salem, ORN299KCKings County Sheriff'S Office · Hanford, CAN299MCN299mc LLC · Auburn, WAN299SPNorth Dakota Highway Patrol · Bismarck, NDN29AJWest Alabama Aviation Leasing LLC · Tuscaloosa, ALN29NPCrown Air LLC · Bend, ORN29PMAlly Mohamed Yacoob · Fort Lauderdale, FLN2DMWiley Post LLC · Lewes, DEN2GTT20608770 Inc Trustee · Wilmington, DEN2KDElliott Frank F · Mojave, CAFirst renewal noticeN2PSUnited States Department Of The Interior · Boise, IDN2SLLowe Aviation LLC · Bountiful, UTN30038Stockyard LLC · Wilmington, DEN3005YGreen Acres Aviation LLC · Berryville, ARN300HCPs Air LLC · Evansville, INN301EBQuesnel William G · Truckee, CAN30268Rudd Terry R · Clarkston, WAN30280Emery Clint L · Texarkana, ARN302STManagement Support Services LLC · Naturita, CON302WDAmado'S Holdings LLC · Rice, MNN30374Canihan William R · Novato, CAN303HBFly The Coop LLC · Newton, KSN3040MAustin 206 Aviation LLC · Americus, GAN30453Lehman Land Management LLC · Vernon, TXN30516J A Sutherland Inc · Ukiah, CAN30530Banegas Jose C Zankiz · Fort Myers, FLN305JGAbeona-Adeona Aviation LLC · Wilmington, DEN305MTMtc Air LLC · Homestead, FLN305WAMy Way Aviation LLC · Weston, FLN305WTToro Procurement LLC · San Angelo, TXN30644Registered aircraftN306CSSecurity Alert Aviation LLC · Gilroy, CAN30777Huff Charles Christopher · Midland, TXN307CSDetwiler Jeffrey D · Lancaster, PA
Back to AD 2012-10-52