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.
N605LMBst Cirrus LLC · Mooresville, NCN605MHSteinberg Kenneth R · Longport, NJN605PTLoguidice Kevin · Hillsborough, NCN605RMClear Prop Aviation LLC · Palo Alto, CAN605TFOpportunity Knocks LLC · Sioux Falls, SDN605WKJ4 Aviation LLC · Brooks, GAN60636Allard Michael L · Penrose, CON6067TSullivan Patrick V · Chicago, ILN6069PAirborne Helicopters LLC · Hendrum, MNN606BCBell Camp Inc · Lubbock, TXFirst renewal noticeN606CTPkck Plane LLC · Newton, MAN606KHWood & Wood Aviation LLC · Boaz, ALN606MFAtaraxia Aircraft Holdings LLC · Greenville, SCN606PPAndriopulos Salguero Inc · Hialeah, FLN606REPebblebrook Aviation LLC · Ellinwood, KSN606WMHolt Timothy L · Foristell, MON6071BRoss Bryan L · Marion, MSN607GSGaines Robert G · Howell, MIN607JDJd 707 Air LLC · Edgerton, OHN607PCCidale David R · Grand Island, NYN607TL100% Made In The USA Bully Tools Inc · Steubenville, OHN6083BListo Aviation LLC · Lewes, DEFirst renewal noticeN6084BCenturion Aviation Ltd · Salina, KSN6088PSide Deck Event Management LLC · Lexington, SCN608AEFreedom Aviation LLC · Weatherford, TXN608CAPlane Goat Resources LLC · Canyon Lake, TXN608CDHorizon Ventures Inc · Fayetteville, ARN608FDMjd Yuma Enterprises LLC · Yuma, AZN608JSJuliet Sierra Enterprises LLC · Dallas, TXN608SRMachugh Cliffton D · Albany, ORN6094BT 210 Telluride Corp · Aspen, CON6098XKeystone Aerial Surveys Inc · Philadelphia, PAN6099WGriffith Aviation Co · Tulsa, OKN609AEGundersen Erik · Chino Hills, CAN609AYAikawa Medical Management Co Inc Trustee · Cheyenne, WYN609CThorson Gregory · Mequon, WIN609CDCavu Aviation LLC · Huntsville, ALN609DWith Pride Aviation LLC · Farmingdale, NYN609KGGeiger Aviation LLC · Wilmington, DEFirst renewal noticeN609MRScudder Aviation LLC · Enid, OKN609RLT And B Mgmt LLC · Las Vegas, NVN60AMCleveland Flying Inc · Cleveland, MSN60CFArq Aviation LLC · Wilmington, NCN60DMDatom Inc · Culver City, CAN60DNNlw Inc · Indianapolis, INN60DRSudeep Singh Flllp · Clovis, CAN60DWJohnson Boyd · Apple Valley, MNN60EDawson Aircraft Inc · Clinton, ARN60HSProfile Holdings Inc · Newmarket, NHN60JHRdu Aviation LLC · Raleigh, NC
Back to AD 2012-10-13