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.
N2237QJenkins John E Jr · Long Valley, NJN2237SOregon State Police · Salem, ORN2238GRupp Aviation LLC · O Fallon, MON2238HRhodes Mike A · Independence, ORN2238LDeris Jeffrey J · Madison, MSN2238UHewitt Robert E · Bybee, TNN223APJuliet Aviation LLC · Oregon City, ORN223BCuster Charles D · Destin, FLN223BDN223bd LLC · Fresno, CAN223BWBridgewater State University · Bridgewater, MAN223CKBounds Keith A · Thomson, GAN223DAAerodrome LLC · Louisville, KYN223HFHeritage Asset Leasing LLC · Ronkonkoma, NYN223JHKp Aircraft LLC · Waco, TXN223KMccroskey Wesley D · Kingston, TNN223KCNovember Alpha LLC · Dover, DEN223LPChristiansen Aviation LLC · Wilmington, DEN223MDPremier Engineering Inc · San Antonio, FLN223MEChem-Air LLC · Shreveport, LAN223MGBuffalo Sales & Leasing LLC · Missoula, MTN223MSNy Dc LLC · Washington, DCN223NKWandering Vet LLC · Mccook, NEN223PTPlowman Holdings LLC · Willmar, MNN223RSJsh Farms Inc · Hermiston, ORN223TATomlinson Aviation Inc · Ormond Beach, FLN223UKWilliams Pat P · Salem, ORN223VAVeracity Aviation LLC · Seguin, TXN223WWSan Diego Flight Training Inc · San Diego, CAN223YZMeridian Aircraft LLC · Wilmington, DEN223ZAlpha Tango Aircraft LLC · Wilmington, DEN2240BK & D Dakota LLC · Avon, OHN2241Davis Clint H · Paola, KSFirst renewal noticeN22419Gehres Shawn E · Enterprise, ALN2241BHanneman Michael W · Abilene, TXN2241GOwens Wilbur · Rch Palos Vrd, CAN2241NBell Michael C · Sammamish, WAN2241ULatimer Mark A · Roanoke, TXN2241VEdwards John D · Yardley, PAN2241YHenault Benjamin · Archdale, NCN2242CCac Of Ar LLC · White Hall, ARN2242FKoester Thomas C · West Chester, PAN2242LDeyoung Jeffrey Scott · Johnstown, CON2242NSt Louis Flying Club Inc · Ellisville, MON2242UAir-Mods Flight Academy Inc · Robbinsville, NJN2242ZN2242z LLC · Newtown, CTN2243FDavenport Mark B · Placentia, CAN2243LMaine Instrument Flight · Augusta, MEN2243PEasterling Richard V DBA · Berkeley, CAN22446Ag Care Inc · Apopka, FLN2244LDerivan Theodore S · Bremen, ME
Back to AD 2006-10-21