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.
N207PDFirefly Leasing Inc · South Carver, MAN207PKDufault Daniel R · Lincolnville, MEN207SADyer LLC · Dyer, TNN207SFTextron Aviation Inc · Wichita, KSN207TJBoos Timothy J · Fort Atkinson, WIN207VRB&C Properties LLC · Bristol, WIN207XBane Russell · Palm Beach Gardens, FLN2080QHyperion Enterprises LLC · Warrenton, VAN20816Dawson Matthew · Springfield, MON20817Beard Russell G · Goodyear, AZN20818N20818 LLC · Wilmington, DEN2081AKing David M · Ormond Beach, FLN2081SPlane Nonsense Inc · Middletown, DEN2081TBaker Holdings LLC · Bedford, PAN20826Lc Aviation LLC · Mocksville, NCN20830Atpce LLC · Wilmington, DEN2083DSale Reported · Crystal, MNSale reportedN2083FDetroit Public Schools Community District · Detroit, MIN20848Lown Jeffrey B II · Shrewsbury, NJN2084ASunrise Aviation Inc · Ormond Beach, FLN2084DWaves4days LLC · El Segundo, CAN2084THeiss Bryan G · Shelby, MIN2085POphelia Aviation LLC · Paradise Valley, AZN2085TBlue Skies Aircraft LLC · Kalispell, MTN20864Dishart Bradley E · Gibsonia, PAN2086RRobison Robert S · Collinsville, ILN2086TEllis Amy E · Santa Rosa, CAN2086WSanders Flight Training Center LLC · Jasper, ALN20873Mang Aero Club · Belleville, MIN2087ASmith Morris A · Odessa, TXFirst renewal noticeN2087DIsaac Mohsen · Venetia, PAN2087PGold Mountain LLC · Kalispell, MTN20884Atpce LLC · Wilmington, DEN20887N20887 LLC · Augusta, GAN2089KBrown Frank J · Cold Spring, NYN2089RSchwettmann Dennis E · Nampa, IDN2089TBeusekom Jeremy Van · Eden Prairie, MNN208CAChristiansen Aviation LLC · Wilmington, DEN208CPChristiansen Aviation LLC · Wilmington, DEN208CWWawock Richard L · Murphy, IDN208DCRay David L · Yelm, WAN208EFAero208 LLC · Boise, IDN208ETSaunders Warren C IV · Oklahoma City, OKN208EZFesta Nerio F · Penngrove, CAN208FT423 East Young LLC · Warrensburg, MON208GGPenn Yan Flying Club Inc · Penn Yan, NYN208PFChristensen Todd S · Ririe, IDN208PHSullivan Farms LLC · Alachua, FLN208THN208th LLC · Villa Rica, GAN2090American Valet Air Inc · Wilmington, DE
Back to AD 2006-10-21