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.
N57PBHyannis Air Service Inc DBA · Hyannis, MAN57PGShirman Leon · Redwood City, CAN57RJD&J Training Planes LLC · Logan, UTN57RXVolar Ix LLC · Edmond, OKN57RZSierra Tango Ventures LLC · Monte Sereno, CAN57SAFort Wayne Aircraft LLC · Fort Wayne, INN57TUKagley Larry D · Greenwood, SCN57TWBc & Tw Flying Service LLC · Hot Springs, ARN57XTLiss Jonathan L Md · Columbus, GAN580EN580e LLC · Hickory, NCN580SRNose Up Speed Aviation LLC · Durango, CON5813MMehta Aviation LLC · Birmingham, MIN5816PWolf Michael A · Rutledge, TNN581CBColorado Baron LLC · Ketchum, IDN581CDLig Air Services LLC · New York, NYN581CVCpc Aviation LLC · Helena, MTN581PFFox Arrow 542 LLC · Jonesboro, ARN581PSBonanza Aviation LLC · Wilmington, DEN581SACalifornia Industrial Rubber Co Inc · Fresno, CAN581SDDakota Cross Winds LLC · Bismarck, NDN581SHShowtime Aviation LLC · Frostproof, FLN581THCirrus Design Corp · Duluth, MNN5825MLee Brian P · Kent, WAN5826CBank Of Utah Trustee · Salt Lake City, UTN5827MHopland Steve · Johnson City, TNN582SBHardy Gordon H · Belmont, CAN582TSage Sky LLC · Telluride, CON582TAWiday John P · El Cajon, CAN583CDInternational Air Services Inc Trustee · Carson City, NVN583CFFox Aviation LLC · Hattiesburg, MSN584BSch Aviation Inc Trustee · NorfolkN584CDBrothers David M Trustee · Cainsville, MON584CFGreenspace Of Virginia LLC · Forest, VAN584CPThorpe LLC · Jupiter, FLN584DBWhiskey Bravo Air LLC · Dover, DEN584DFHangar 3 LLC · Milledgeville, GAN584DSRose Michael · Prescott, AZN584DTTiger Flight LLC · Florence, SCN584MBCenterline Holdings Inc · Camden, DEN584MWRela Matthew V · Monroe, NJN584SRThunder Richard · San Diego, CAN584WKing Air Ny LLC · Schenectady, NYN5854AColorado High Plains Aviation Ltd · Englewood, CON5858Campbell Joshua · Dallas, TXN5858PMatherne David M · Houma, LAN585ABHh Aircraft LLC · Englewood, CON585CDE And J Holdings 25 LLC · El Dorado, ARN585CFBuzzing Above II LLC · Tampa, FLN585ECMc Aviation II LLC · West Palm Beach, FLN585GBCirrus Design Corp · Knoxville, TN
Back to AD 2012-10-13