AD 2012-10-13
Registered aircraft · 13,306
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-13')
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-13')
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-13') 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-13') 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.
N556KAPink Sputnik LLC · Wilmington, DEN556LInternational Air Services Inc Trustee · Carson City, NVN556PLSerenity Skies LLC · West Chester, PAN556SROhaver Aviation LLC · San Antonio, TXN557CACci Air LLC · Dell Rapids, SDN557CCRedhawk Aviation LLC · Mccomb, MSN557RMWest Street Partners Ltd · Litchfield, CTN557SASouthard Dennis W Trustee · Tulsa, OKN557XXBurnett Aviary LLC · Longview, TXN558ATSkywalker Aviation LLC · Jacksonville, FLN558CDSr Global Partners LLC · Laguna Beach, CAN558PSouth Electrical Inc · Laurinburg, NCN558PGConverting Solutions Inc · Maiden, NCN558RSAyelet Aviation LLC · Mackinac Island, MIN558SRAllenergy Aircraft LLC · Trego, WIN558THScannelli Jeff · Southampton, NYN558USNorth Central Dakota Partners LLC · West Fargo, NDN558WHRex Aero LLC · Wilmington, DEN5591ABig Dog I LLC · Wallace, MIN5591VCortese Michael C · South Chatham, MAN5593CSouth Coast Aviation LLC · San Diego, CAFirst renewal noticeN5594CNovember Inc · Murfreesboro, TNN5598GNorth River Investments Inc · Palmetto, FLN559ACRebel Air LLC · Oxford, MSN559CFBlair Church & Flynn Consulting Engineers · Clovis, CAN559MMScience Brew LLC · Kenosha, WIN559MSHeavy Metal Air LLC · Farmingdale, NYN559RRN559rr LLC · Owasso, OKN559SRSky West Aviation Inc Trustee · Albuquerque, NMN559TTMcdonald Aviation Mgt LLC · San Jose, CAN559WMUniversal Aviation Holdings LLC · Wilmington, DEN559WTWingz Aero LLC · Newport News, VAN55ABAllan Michael D · Forney, TXN55AQAircrete LLC · Tulsa, OKN55CMCamille Ventures LLC · Odessa, TXN55CQCq Aviation LLC · North Plains, ORN55CTFly 55 LLC · Winter Springs, FLN55FBCirrus Design Corp · Duluth, MNN55GYArrokoth LLC · Virginia Beach, VAN55KCBloch Jeremy · San Francisco, CAN55KSPerlan LLC · Melbourne, FLN55KWFurr Randy Wilburn · Pleasanton, CAN55LLangdon Charles V Jr Trustee · Shingle Springs, CAN55LPAir Flight Inc · Fort Lauderdale, FLN55LTRegistration Pending · Tucson, AZRegistration pendingN55LWLeeward Aero Sales Corp · Ocala, FLN55MMRsx11 LLC · Redmond, WAN55NWLr Aviation LLC · El Paso, TXN55PPChaffey Community College District · Rancho Cucamonga, CAN55RBGots To Go LLC · Wilmington, DE
Back to AD 2012-10-13