AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N3202CJohnson Jeremiah · Fairbanks, AKN3202LMatta Figueroa Eduardo · Chapman, KSN3203UKuykendall Kirk O · Lakeside, ORN3204DGriffith Sherman · Southlake, TXN3204JBecker Charles A · Rice Lake, WIN3204UBlue Sky Flyers Inc · Punta Gorda, FLN3204XKulesza Roman · Noblesville, INN3205DWest James · Monroe, MIN3205UBanducci Debra L Trustee · Bakersfield, CAN3205XAvery Jackson R · Ontario, ORN3206DDenny Michelle L · Chugiak, AKN3206EMorey Airplane Company Inc · Middleton, WIN3206SHall David J · Red Bluff, CAN3207EArmstrong Aviation LLC · New Orleans, LAN3207SSouthern Star Aviation LLC · El Campo, TXN3207UTaf Aerial Services LLC · Beeville, TXN3208JLandon Christopher L · Portland, ORN3208SZirul James V · Kenai, AKN3208UDiller Larry K · Fairview, MIN3208XRhodenbaugh Mitchel D · Wyndmere, NDN3208YHamilton Triple C Farms · Ririe, IDFirst renewal noticeN320DDBronson Robert D Trustee · Prineville, ORN320PCAom Aircraft LLC · Wilmington, DEN320RMRd Harrison Inc · Lexington, NCN320SWEast West Investment Advisors LLC · Sandy Point, VAN3210PKilcullen Brian DBA · Fort Lauderdale, FLN3210SGore Range Aviators LLC · Kremmling, CON3210UHaas Todd · Pecatonica, ILN3210YBergren William · Des Moines, IAN3211DNielson Donald L · Independence, ORN3211EApm Leasing LLC · Casper, WYN3211JGo Captain LLC · Lake Worth, FLN3211SNoble Tom R · Winnsboro, TXN3211YFour M Properties LLC · Prague, OKN3212JBrown Joseph E · Palmdale, CAN3212LBlackstone Rotorcraft Inc · Hartselle, ALN3212TRichmond Timothy R · Deland, FLN3213SRosengrants Matthew R · Walsh, CON3213XAlrubaiie Ihssan R · Fort Worth, TXN3213YFletcher Jerry D · Yukon, OKN3214TJohnson Hugh S · Rochester, NYN3214UBibus Michael A · Austin, MNN3215TMcgee Debra L · Tuscola, TXN3215XVoltmer Benjamin P · Excelsior Springs, MON3216EChrabot Gerard S · Virginia Beach, VAN3216MN3216m Inc Trustee · Carson City, NVN3216TWss Aviation Inc · Jerseyville, ILN3216VTwo Dot Aircraft LLC · Kalispell, MTN3217JMalinchak Louis Trustee · Bristow, OKN3217SGrotbeck Christopher L · Albuquerque, NM
Back to AD 97-01-13