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.
N661SRCirrus 22 LLC · Woodbury, CTN6621AJc Investors Group LLC · Coral Springs, FLN6622CMidnight Flight LLC · Wells, TXN6622YSierrakilo LLC Trustee · Lewes, DEN662CACirrus Plans LLC · Fort Myers, FLN662DPValiair Limited Co Trustee · Casper, WYN6631CD Porter Enterprises LLC · Dickinson, NDN6634PAviation-Avsec Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN6638NIsr Aviation LLC · Wilmington, DEN663AAHyannis Air Service Inc · Hyannis, MAN663CDCirrus Sr22 1847 Inc · Wilmington, DEN663KKQualitair LLC Trustee · MichelstadtN6640CGospel Ministries International Inc · Collegedale, TNN66411Cirrus Design Corp · Duluth, MNN6641TAx3 LLC · Decatur, TXN6641WLandlund Flying LLC · Oroville, CAN6643EReynolds Ronnie · White Hall, ARN6643PRobert Yost Enterprises Inc DBA · Saint Francis, KSN6644QLomakin Anatol · Lincoln Park, NJN6646ZN1437a LLC · Delray Beach, FLN664PHInnovation Aviation LLC · Russellville, ARN664RJGeneva Lakes Aviation LLC · Lake Geneva, WIN664TT4mediation LLC · Lake Wales, FLN6650HN6650h LLC · Edmond, OKN66529King Warren D · Bend, ORN6652JAir Chairs LLC · Austin, TXN6654LRomeo Air LLC · Missoula, MTN66568Trapp Aviation Ltd · Lebanon, OHN6657TPilot-Ready LLC · Lime Springs, IAN66585Haines Jay A · Summerland Key, FLN6658ZClark Lloyd E · Hanover, MDN665CARubemore LLC · San Antonio, TXN665CWAmro Air LLC · Folsom, CAN665DMCyclone Aviation LLC · Macedonia, IAN665KAKallman Aviation LLC · Henderson, NVN665SCGold Star Beacon LLC · Sarasota, FLN6661NSmith Joel L · Cedar Park, TXN6664LTt Aviation LLC · Oxnard, CAN6665WIal Corp · Lewes, DEN6666ATvpx Ars Inc Trustee · North Salt Lake, UTN6667NSmith William F · Hindsville, ARN6669XEdm-Van LLC · Maple Lake, MNN666AJN666aj Inc Trustee · Wilmington, DEN666EBQualitair LLC Trustee · MichelstadtN666FUTouch N Go Gnv LLC · Alachua, FLFirst renewal noticeN666KDAircraft Guaranty Corp Trustee · Oklahoma City, OKN6670GSterling Park Corp · Ashland, KYN6671Euroaviation Inc Trustee · KematenN6672CBayview Direct LLC · Dover, DEN6674CAire Tracks Corp · Wilmington, DE
Back to AD 2012-10-13