AD 60-12-01
Registered aircraft · 2,103
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:60-12-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:60-12-01')
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:60-12-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:60-12-01') 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.
N10133Fisher Charles R Jr · San Antonio, TXN10145Hensarling Matthew L · Elizabeth, CON1022THansen Jed D · Clark, SDN1046WGoodin Ross W Jr · Enterprise, MSN105BMatthews George W · Hillsboro, OHN105ERSokoloski James J · Lampasas, TXN1069Byrne Sofia V · Merrimack, NHN106BAnderson Martino G · Lakeland, FLN1084WLafayette Foundation Inc · Fort Lupton, CON108BCaturia Jeffrey T · Layton, UTN109AKHarris Eric W Jr · Moncks Corner, SCN109DSBell Bradley L · Bothell, WAN109FRoos Patrick R · Purcellville, VAN10EVCafiero Vincent · Haskell, OKN10GGMartinelli Alexander Joseph · Waco, TXN10RRLeonard Christopher S · Moravia, NYN10WRWilson Keith · Saint Joseph, MIN1101WObrien A Scott · Camarillo, CAN1102VRaimondi Jennifer Le · Rancho Murieta, CAN110DBStarnes Robert D · Lavonia, GAN1115YSmith Phillip · Arlington, TXN111BWKnudsen Kent A · Rosenberg, TXN111KMJohnston Cheryle L · El Centro, CAN114SIrby Darrell L · Keller, TXN116FTaylor John · Mammoth Spring, ARN117DPMccollum Michael T · Camarillo, CAN119DDColeman Russell L · St Charles, ILN119EDCentral Virginia Aviation Inc · North Dinwiddie, VAN119WRatliff Hayden N · Clarkesville, GAN11AXLoukopoulos George Matthew · Tucson, AZN11ESale Reported · Wayne, NESale reported, canceledN11FCCooper Matthew A · Seattle, WAN11FPShannon Rcs LLC · Kalispell, MTN11FZHolguin Steven · Hayward, CAN1208UPulliam Anthony L · Lancaster, CAN120WMLift Enterprises LLC · Lynn Haven, FLN1220Technical Education Services Inc T/A · Virginia Beach, VAN122LDennis Harley E Sr · Cole Camp, MON1234BSmith Bradley T · Elizabethtown, KYN123BNickravesh Niknam · Saratoga, CAN123JVDowning Danny L · Kilgore, TXN124RSHenley Charles D · New London, NCN125BCrow Jerry W · Louisville, TNN127TBTorongo William Martin · Grayling, MIN128XHaynes Bruce A · Welches, ORN129BTinney William G · Macon, GAN12HMRigsby Robert A · Burien, WAN131BMillspaugh John · Weatherford, OKN132YCarr Scott A · Allen, NEN133MGolden Age Flight Museum · Bakersfield, CA
Back to AD 60-12-01