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.
N6748PSpears Derek · Los Angeles, CAN6748VCannon Oil & Gas Well Services Inc · Rock Springs, WYN674CDEagle Air US Inc · Eau Claire, WIN674KYMorning Star Aviation LLC · Houston, TXN674MMNaples Airport Properties 2 LLC · Pittsboro, INN674PCLegal Wings I LLC · Overland Park, KSN6750CTisdale Enterprises LLC · Pensacola, FLN6750VSouth Delta Aviation Inc · West Helena, ARN6752XIyer Vijay · Mammoth Lakes, CAN6753HJsy Aviation LLC · Port Angeles, WAN67586Carwashos LLC · Colorado Springs, CON6758XAc Green LLC · Athens, OHN6759RRegistered aircraftN675ATRegistered aircraftN675CBWe B Flyers Ltd · Wilmington, DEN675CMPaxton Ventures LLC · Encinitas, CAN675RVb Flying LLC · Cornelius, NCN675SPPlane Fun Aviation LLC · Bradenton, FLN675SRCirrus Sr22 2776 Inc Trustee · Wilmington, DEN675WHayes Richard J · New Smyrna Beach, FLN6765THyannis Air Service Inc · Hyannis, MAN67664Hukill Ryan R · Eagle Point, ORN676MLNielsen Mark Andrew Trustee · Pagosa Springs, CON676PBCobalt Ventures LLC · Aurora, ILN6778NMountain Skylane LLC · Loveland, CON67799Piper Arrow LLC · Yarmouth, MEN6779BRegistered aircraftN677ALCirrus Design Corp · Duluth, MNN677CAHyannis Air Service Inc · Hyannis, MAN677CDInternational Air Services Inc Trustee · Carson City, NVN677CPSweet Spot Consulting LLC · Fort Myers, FLN677JMJsm Aviation LLC · Rochester Hills, MIN677LMErval Aviation Holdings LLC · Santa Rosa Beach, FLN677MBChaves Carlos A · San Juan, PRFirst renewal noticeN677MDSt Pete Aviators LLC · St Petersburg, FLN677RCAlinejad Nima Allen · Reno, NVN6787RJensen Leland · Idaho Falls, IDN67886Hyannis Air Service Inc DBA · Hyannis, MAN6789YMcdonough Patrick J · Defiance, OHN678APSky Guardian Aviation LLC · Pensacola, FLN678BWElem Enterprises LLC · Wilmington, DEN678CDFrogman Flight Ops LLC · Wilmington, DEN678CGTravel Solutions America LLC · Dodson, MTN678CTSanborn Thomas W · College Station, TXN678DADiscovery Aviation Inc · Discovery Bay, CAN678DFForney Dylan · Murchison, TXN678ECCavu Holdings LLC · Greensboro, GAN678GEBlackwell Aviation LLC · San Jose, CAN678GWAtterrissage LLC · Healdsburg, CAN678HDawson Aircraft Inc · Clinton, AR
Back to AD 2012-10-13