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.
N15473Cerniglio Dominic Antonio · Sebastopol, CAN15475Ortega Chris A · Santa Fe, NMN15476Lengacher Caleb Lee · Montezuma, GAN1547XKoch Steven T II · Brownsburg, INN15483Tnj First Class Flying Properties LLC DBA · Dallas, TXN1548PUS Aviation Training Solutions · Titusville, FLN1548RJohnson Jimmy G A III · Edmond, OKN1548XSouthern Turf Services LLC · West Palm Beach, FLN15493Midwest Flying Service Inc · Elgin, NEN15494Freisitzer Roland Franz · Charlottesville, VAN15498Universal Management And Mainteneance Co Inc · Enid, OKN154ARPiper Aircraft Inc · Vero Beach, FLN154BJDent Air Ltd · Annapolis, MDN154BZGrund Joseph R Jr · North Cape May, NJN154DCRocha Jonathan · Prescott Valley, AZN154DSIn Flight Aircraft LLC · Howell, MIN154MASportsman Airpark Inc · Newberg, ORN154PAParagon Airplane Leasing Co · Fort Myers, FLN154RVLavalley Thomas L · Colorado Springs, CON154SHSpitzer Helicopter LLC · Woodland Hills, CAN154WWAlpha Whiskey 1 LLC · Brandon, MSN154ZJAttitude Aerobatics LLC · Wilmington, DEN154ZPAirsign Airships America LLC · Williston, FLN1550XVictors Vectors LLC · Valparaiso, INN15510Lok Kevin K · Upper Sandusky, OHN15514Smedsmo Darrin A · Roseau, MNN1551SVoelker Craig C · Mount Pleasant, IAN15523Derryberry Clay · Lewisburg, TNN15524Brown Gerald · Apple Valley, MNN15526Reynolds David K · Bastrop, LAN15529Pattie Donald D · Zephyrhills, FLN15534Daly James Kieran · Hopewell, NYN15537J & J Aviation LLC · Thedford, NEN15538Schwartz David · Lakeland, FLN1553XGreat Divide Aircraft LLC · Louisville, CON15545Ungaro James P Sr · Las Vegas, NVN1554XBertagna LLC · Chico, CAN15551Buchanan Jennings R · Cocoa Beach, FLN15552Crate Inc · Humboldt, NEN15554Hogan James · Winter Garden, FLN1555RDickenson William P · Lockport, NYN15561Campbell Andrew S · Lake Havasu City, AZN15562Hulihan Tom · Eerie, CON15564Santi Cali Aviation LLC · Longwood, FLN1556XMills Donald Lee · Arlington, TNN15579Korb Thomas M · Owasso, OKN15583Hde Aviation LLC · Omaha, NEN15589Neal Alan B · Cherry Valley, CAN1558RTaylor Scott Douglas · Bethlehem, CTFirst renewal noticeN15596Blue Dog Flyers LLC · Bozeman, MT
Back to AD 2006-10-21