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.
N28110Cae Aviation Academy Phoenix LLC · Mesa, AZN28114Cae Aviation Academy Phoenix LLC · Mesa, AZN28115Cae Aviation Academy Phoenix LLC · Mesa, AZN28119Page Gregory G · Roosevelt, UTN2811MSale Reported · Rio Grande City, TXSale reportedN2811RLantz Raymond J · Huntington Beach, CAN2811WRegistered aircraftAssigned, pending cancellationN2812VKennison Daniel J · Las Vegas, NVFirst renewal noticeN2812YThor And Associates Inc · Montgomery, TXN2813Piper Aircraft Inc · Vero Beach, FLN28138Todd Jared · Victoria, TXN2814PSargent Wayne M · Bremerton, WAN28154Cae Aviation Academy Phoenix LLC · Mesa, AZN28160Sobol Anthony J · Sandia Park, NMN2816GGiles Aviation LLC · Spring, TXN2816NAlford Hobart R · Palm City, FLN2816RBipes Anthony G · Forest Lake, MNN28170Stracar Miro · Syosset, NYN2817C2817c Inc · Wilmington, DEN2817D2b Group LLC · West Dundee, ILN2817LHopkins Dennis L · Bark River, MIN2817RHunt Loren M · Nevada, MON2818AHengemuhle Ronald J · Long Prairie, MNN2818MMarotta Robert J · San Diego, CAN2818SAviator Antics LLC · Grand Forks, NDN2818XBarr Suzanne Renee · Cape Coral, FLN2819DAicg Group I LLC · Sheridan, WYN2819FMacair LLC · Kennesaw, GAN2819TMelvin Haigis Jr · Bardstown, KYN281AFState Of Louisiana · Baton Rouge, LAN281AWWebb Alan J · Medford, ORN281BAnderson David R · Sycamore, ILN281BLWingsleasing LLC · Wichita, KSN281CAppel Daniel E · Redfield, SDN281DKN281dk LLC · Brandywine, MDN281EAElevation Air Capital LLC · Janesville, WIN281HPMuggles Ltd LLC · East Fallowfield, PAN281PEBravo Leasing LLC · Daytona Beach, FLN281TWSkywest Leasing Inc · St George, UTN281WYBig Sky Aviation LLC · Woodstock, ILN281XSelanders Jay N · Smithville, MON28200Holland Joshua · Glendale, AZN2820JChabot Nicholas · West Hartford, CTN2820NMontana Tvl Aviation LLC · Kalispell, MTN2820SJh Unlimited LLC · Kalispell, MTN28214Wellum Jeffrey B · West Terre Haute, INN28218Bottorff Todd N · Roachdale, INN2821GH&M Air LLC · Metamora, MIN28220Registered aircraftN28222Just Plane Erie LLC · Erie, CO
Back to AD 2006-10-21