AD 2012-01-11
Registered aircraft · 3,100
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-01-11')
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-01-11')
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-01-11') 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-01-11') 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.
N17ECLinggi Asset Holdings LLC · Sheridan, WYN17EUCirrus Design Corp · Duluth, MNN17JTCirrus Design Corp · Duluth, MNN17KDAht Aviation LLC · Doral, FLN181BCBlue Chip Aviation Services LLC · Cincinnati, OHN181CCLegacy Air Services LLC · Lafayette, LAN181DBPleasant City Aviation LLC · Shelby, NCN181MKHarlow Builders Inc · Troy, OHN181SPIkway Air LLC · St Charles, ILN181WRunway Group LLC · Bentonville, ARN1822FFoxtrot Tango Aviaiton LLC · West Palm Beach, FLN183CACloud Asset LLC · Thomasville, GAN183KSN183ks LLC · Houston, TXN183PHVestal Aviation LLC · Thomasville, NCN183SFGrand Cove Support Services LLC · Denver, CON183SRRyder Aviation LLC · Tucson, AZN183XIcg Aviation LLC · Ankeny, IAN184MCWest Houston Flippers LLC · Dallas, TXN184MGClt Aviation LLC · Loxahatchee, FLN184PMMccoy Michael A · Granbury, TXN186CGPine Needle Air LLC · Santa Rosa Beach, FLN188AJA&J Specialties LLC · Hickory, PAN188LSJms Small Aircraft Fl LLC · Aventura, FLN188MHAndree'S Avion LLC · Santa Fe, NMN189MCThree Thirty Three LLC · Wilmington, DEN189PWArrivee LLC · Manhattan Beach, CAN189STSierra Tango Aviation LLC · Colleyville, TXN18AS1607 Vistas LLC · Fort Lauderdale, FLN18BCT-Air LLC · Schofield, WIN18CKHatch Aviation LLC · New Braunfels, TXN18CYBraylin Air LLC · Jupiter, FLN18EUCirrus Design Corp · Duluth, MNN18PYHeavenly Flight LLC · Cumming, GAN18SYWingz Wi LLC · Milwaukee, WIN191AHCirrus Sr22t Athens Blue Inc Trustee · Wilmington, DEN191JBGraeves Auto & Appliance Inc · Olney, MDN191WLHatchery Investments LLC · Truckee, CAN191WTBrightpipe Air LLC · Mableton, GAN1924W1824 Whiskey LLC · Golf, ILN192BCLeo Aviation Inc · Rogers, ARN1931MAnchor Aviation LLC · Johnstown, CON194DCA440 Holdings LLC · Brentwood, TNN1957CJbc 514 Capital Holdings LLC · Santa Ana, CAFirst renewal noticeN195CSTritten Aviation LLC · Weston, WIN195MBRoom For More LLC · Salt Lake City, UTN195WPWhiskey Papa Aviation LLC · Atlanta, GAN1971CAndrews Aviation LLC · Columbia, MON1974GAirmax LLC · London, KYN1975Henay Air LLC · Windermere, FLN1975PBarry Aviation LLC · Boise, ID
Back to AD 2012-01-11