AD 2012-03-52
Registered aircraft · 522
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-03-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-03-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-03-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-03-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.
N221VArea 52 Holdings Inc · Darlington, SCN2220NDushek Matthew S · West Hartford, CTN2228DAircraft Guaranty Corp Trustee · Oklahoma City, OKN2228KSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2229FMulligan Aviation LLC · Janesville, WIN222GXBorchert Ronald L · Richfield, OHN222JFCline Denis Jay Trustee · Colton, CAN222VSCharlie Rogers Ford Inc · Dayton, TNN224GMVerboski Timothy W · Azle, TXN233KTWelch Jackie L · Victoria, TXN234WSMancini Gary Ray · Livermore, CAN237RBMed Ex LLC · Shiloh, ILN237RPPohlner Roger E · Fisher, ARN241KTRiley Robert V Jr · Hattiesburg, MSN241SGFalasco Joseph R · Little Rock, ARN242MDSpyder Flights LLC · Manchester, PAN242REAdvanced Avionics LLC · Cookeville, TNN242TNBycroft Kathleen A Trustee · Salina, KSN242WTMsm Enterprises LLC · Portland, ORN246PCLna Flyer LLC · West Palm Beach, FLN249SAGribble Ted A · Paris, TXN251PCarolina Real Estate Consultants LLC · Pickens, SCN252MASbkb Aviation LLC · Henderson, NVN257TMSunrise Aviation Group LLC · Kalispell, MTN261JMHundal Medical Corp · Malibu, CAN267CTBachlechner Thomas Christian · San Diego, CAN26FFFastfun LLC · Fort Myers, FLN26YValiair Lc Trustee · Casper, WYN276CMTwo Fly Guys LLC · Orlando, FLN278DBCt42 LLC · New York, NYN278SBKyle Benjamin LLC · Marriottsville, MDN2811AAdrien Aviation LLC · Rochester, MIN2820BChildress Kenneth W · Longview, TXN288DMDavidson Christian · Auburn, WAN2903GMooney Wormtail Padfoot And Prongs LLC · Kalispell, MTN299AGSky West Aviation Inc Trustee · Albuquerque, NMN299LG2 Huskies LLC · Sheridan, WYN29EMIngram Earl · San Marcos, TXN2ALAl Corporation · Wilmington, DEN2SAInternational Air Services Inc Trustee · Carson City, NVN300MESjk Aviation LLC · Orland Park, ILN31007M&E Air LLC · San Marcos, TXN311PDHaehnle Michael J · Milford, OHN311TNB & B Aviation LLC · Evansville, INN312DKline Robert H · Oley, PAN312TNUltimate Internet Access Inc · Wrightwood, CAN313TNSouthern Comfort Horizons LLC · Naples, FLN316TNBfo Inc Trustee · Wilmington, DEN321ELBecker Ronald G · Cresson, TXN321FFInternational Air Services Inc Trustee · Carson City, NV
Back to AD 2012-03-52