AD 2012-16-14
Registered aircraft · 779
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-16-14')
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-16-14')
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-16-14') 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-16-14') 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.
N2511BDealer Equipment Leasing LLC · Miami, FLN251SPSonoco Products Co · Hartsville, SCN253ALCorsair Two LLC · Hillsboro, ORN253RM452053 LLC · Fort Lauderdale, FLN253SCPowderhorn Aviation LLC · Bethany, OKN254ALCorsair Two LLC · Hillsboro, ORN254FSS&S Aviation Management LLC · Waco, TXN254SBHawker 800xp LLC · Fort Lauderdale, FLN254TLHdsmjj LLC · Waco, TXN256AHApple Six Hospitality Air LLC · Richmond, VAN258UTBurnt Orange Five LLC · Seabrook, TXN259RHAlliance Aviation Group LLC · Wilmington, DEN25XPRd Airways LLC · Channelview, TXN260LFEthos Aviation LLC · Cleveland, OHN261CHSeecon Builders Inc · Concord, CAN263SNBlue Skies Hawker LLC · Whitefish, MTN264CDf 254 Holdings LLC · Wilmington, DEN264RVHfa Specialty Acquisitions LLC · Boca Raton, FLN265CWOde Family Logistics LLC · Strongsville, OHN265HTmfb Transporation LLC · Orlando, FLN265JGShell Mountain Ranch LLC · Cranfills Gap, TXN266AJMoore Investment Fund LLC · Belmont, OHN268TMTmrg LLC · Nashville, TNN268TSExpeditus Holdings LLC · Jacksonville, FLN26XPBanyan 2025 LLC · Fort Myers, FLN271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN275ERContinuum Aviation LLC · Oklahoma City, OKN276LJExpedite Aviation LLC · Westerville, OHN277RSMaize & White Aviation LLC · Youngstown, OHN27KB3kb Investments LLC · Wilmington, DEN280BDLcg Enterprises LLC · Greenwich, CTN286JJHoran John J Jr · Dallas, TXN28NPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN28VMVan Metre Air LLC · Fairfax, VAN290GSBank Of Utah Trustee · Salt Lake City, UTN291BBattelle Memorial Institute · Columbus, OHN291FJNhs Management LLC · Tuscaloosa, ALN298RDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN299PRMeregrass Inc · Dublin, TXN29BBattelle Memorial Institute · Columbus, OHN29JWSchussboomer Systems Inc · Anacortes, WAN29REHome State Insurance Group Inc · Waco, TXN2HZHerzog Contracting Corp · Saint Joseph, MON3007Empire Airlines Inc · Lebanon, MON301MLAirtime Aviation LLC · Bethesda, MDN301RJ301rj LLC · Fayetteville, ARN302RVAero Jet Aviation I Inc · Fort Lauderdale, FLN303XX303 Aviation LLC · North Plains, ORN305BBBsc Landing LLC · Saint Louis, MON305FCN305fc LLC · Opa Locka, FL
Back to AD 2012-16-14