AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2746CChen Mark · Plano, TXN2746YDavenport Jimmy J · Hayesville, NCN27471Grant Aviation Inc · Anchorage, AKN27478Hughes Ronnie D · Cedar Park, TXN2747RWilliams Dwight M · Paragould, ARN2747YJennflight Inc · Chagrin Falls, OHN27481Sanborn Map Company Inc · Colorado Springs, CON2748FWirth Gerald J Trustee · New Lenox, ILN2748WZweifel Jonathan R · Chandler, AZN2749YBaker Paul D · Grand Prairie, TXN274AMMc Communications LLC · Conway, ARN274CTGoodwin Roger I · Palm Coast, FLN274CWWilson Chuck W · Mckinney, TXN274DGBourne Michael Paul · Crystal Bay, NVN274DMGustafson James R · Granby, MAN274ERFlying Vikings Inc · Hayward, CAFirst renewal noticeN274GTSkogen Joseph S · Coeur D Alene, IDN274JFerris John A · Priest River, IDN274JP802 21st Street LLC · Paso Robles, CAN274JZAcv Group LLC · Mckinleyville, CAN274LCHuismann Lucas A · Whitehall, WIN274LSBmk Farms · Fowler, KSN274MAHot Wings Aviation LLC · Fishers, INN274MESabra Davis Corp · Wilmington, DEN274MMHanzawa George DBA · Wahiawa, HIN274VWBonanza Parts Inc · Davis, CAN274ZAlpha Tango Aircraft LLC · Wilmington, DEN2750MMcgibbon Aviation LLC · Denver, CON2750WVance John · Coleman, TXN2751Junkins Brent · Killen, ALN27527N27527 LLC · Florence, SCN27528Seacrest Seven LLC · Savannah, GAN2752WL Deckard Aviation Ministries · Waller, TXN2753WGleaton Marcus H · Weatherford, TXN2755BBoyce Aviation Inc · New Port Richey, FLN2755WEast Rick · Muscle Shoals, ALFirst renewal noticeN2755YNancy Aviation LLC · Fayston, VTN27562Montcalm-Mcdonald LLC · Mansfield, LAN27567Plecenik William J · Erwinna, PAN2756WJohnson Stephen C · Lake Tapps, WAN2757WDennis Christopher A · Richardson, TXN2759RFord William(Bill) A III · Abilene, TXN2759WBar F Aviation LLC · Scottsbluff, NEN275AAAoa Kissimmee Inc · Kissimmee, FLN275AMAerodynamic LLC · Aurora, ORN275CBCalifornia Baptist University · Riverside, CAN275CCSellers Richard V · Byron, CAN275CTInfinity Real Estate LLC · Guaynabo, PRN275DFAspen Ring LLC · Bloomington, INN275DHHoward Henry · Justin, TX
Back to AD 2006-10-21