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.
N50ECPremier Wireless LLC · Kalispell, MTN511CZFisher Stephen C · Clarksville, ARN512AGJuliet Leasing Inc · Austin, TXN513CZZiebarth Charles M · Darien, ILN513DRSternhagen Richard · Sweetwater, TNN513ZMBullard Aerospace Corp · Boston, MAN514SGBorland Equipment Leasing LLC · Midland, TXN5151FAoa Capital LLC · Missoula, MTN516EFEckinger Construction Co · Canton, OHN517CBDelaware Aircraft Trust LLC Trustee · New Castle, DEN517PSLuna Volantis II LLC · Lewes, DEN51XMT Bone Flight Services LLC · Santa Monica, CAN521FHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN521SGPerfect Landing Aviation LLC · Highlands Ranch, CON523JTAircraft Partner Holdings Inc Trustee · BerlinN5251FWaypoint Services LLC · Missoula, MTN525VTDsvt Management LLC · Northvale, NJN527TMCampbell Air Services Inc · Roseville, CAN527WMitchell Grayson · Milledgeville, GAN5285PFrank Investments Inc · Austin, TXN5293BBas Part Sales LLC · Greeley, CON5295MPrough Aviation LLC · Stephenville, TXN52KWFreedom Aviation LLC · Alexander, ARN52TFAs The Crow Flies LLC · Belmont, WIN533LJHazelhurst Inc · Middletown, DEN535CCrystal John · Las Vegas, NVN535RFlight Training Pro LLC · Nashville, TNN53WMBurns Ivan · Concord, MAN5515BTwist Air Inc · Overland Park, KSN551USFar Side Aero LLC · Santa Maria, CAN555TJRegistered aircraftN557RMWest Street Partners Ltd · Litchfield, CTN558RMHoffman Aircraft Sales Corp · Wilmington, DEN558USNorth Central Dakota Partners LLC · West Fargo, NDN5611FAdrenaline Airlines LLC · Dallas, TXN562BGFalcon Air LLC · Casper, WYN565PAJim Mardis Aviation LLC · Mount Dora, FLN567RDFranks Properties LLC · Kisciusko, MSN571LLDavis Thomas B · Greensboro, NCN578TAWag Aviation LLC · Billings, MTFirst renewal noticeN57GXJfp Aviation Inc · North Fort Myers, FLN57NGAir 500 LLC · Bastrop, TXN5816PWolf Michael A · Rutledge, TNN595RWCarlgren Jenson E F · Santa Fe, NMN59FMCallison Rodney J · Tucson, AZN606MRAba Aviation LLC · Navasota, TXN606WMHolt Timothy L · Foristell, MON60GXRepp Roger · Aptos, CAN60TYInternational Air Services Inc Trustee · Carson City, NVN611MSSamuel Timothy · Kent, WA
Back to AD 2012-03-52