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.
N75CQWoodlawn Aircraft Leasing LLC · Saint Paul, MNN75CVBeans Fred W · Doylestown, PAN75DAHenderson John L · Ozona, TXN75DMPro-Rentals Inc · Athens, OHN75GBPro Aire Cargo & Consulting Inc · Oshkosh, WIN75GHSaratoga Tc Aviation LLC · Dover, DEN75GLSkyshare LLC · Boulder, CON75HBPretty Aviation LLC · Clayton, GAN75HPN5949s LLC · Hereford, TXN75KCMid-State Construction Co Inc · Livingston, TNN75LBL & A Bennett Second Family Lp · Renton, WAN75LGMarr Lance · Portland, ORN75MGJupiter Am-18 LLC · Red Lodge, MTN75RCJoffe Zalman · Bahama, NCN75RJPalaway LLC · Winter Park, FLN75RMDodson International Parts Inc · Rantoul, KSN75SAGoldbeck Aviation LLC · Columbus, INN75TCoal Creek Avaition LLC · Mcalester, OKN75VJYuvi Dynamics Inc · Tracy, CAN75VRSlt Global Alliances LLC · Las Vegas, NVN75WWSacks David · Fresno, CAN75WZEbc Mt Aviation LLC · Dover, DEN75ZMC & S Aviation · Roswell, GAN7600NKeller Douglas O · West Linn, ORN760CDInternational Air Services Inc Trustee · Carson City, NVN760CHWilliamson Jimmy · Lake Havasu City, AZN760PHopper Marvin · Farmerville, LAN760RMAircraft Partner Holdings Inc Trustee · BerlinN7610CSawtooth Flying Service Inc · Mccall, IDN7610MEickhoff Steven M · Fountain, MNN761BBBeaus Biscuits LLC · Boulder, CON761BDRockwell Richard E · Aledo, TXN761BEAnderson Kristian L · Albuquerque, NMN761BLLong Ernest D · Trabuco Canyon, CAN761BVN761bv LLC · Sioux Falls, SDN761BYB&E Leasing LLC · Dubuque, IAN761BZAltair Aircraft LLC · Gainesville, FLN761CTudo Bem Aviation LLC · Austin, TXN761CECharlie Echo Enterprises LLC · Cedar Hills, UTN761CLUlrick Michael R · Spokane, WAN761CNFrance Sherrod W Trustee · Rawlins, WYN761CTNajm Ziad · Mission Viejo, CAN761CWOne Charlie Whiskey LLC · Austin, TXN761DHSk Sky LLC · Clint, TXN761DLTyler David W · Glendale, AZN761DMHudson William B L · Belvedere, CAN761DNReichman Robert T Trustee · Escondido, CAN761DPSunset Cattle Co LLC · Los Banos, CAN761DSTroutman Alan D · Springtown, PAN761DXFlying Float Club LLC · Tavares, FL
Back to AD 2012-10-13