AD 53-16-01
Registered aircraft · 145
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:53-16-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:53-16-01')
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:53-16-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:53-16-01') 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.
N1252RRunnin Rabbit LLC · Kalispell, MTN1254RGunter Bradley M · Canon City, CON1257RWells Carolyn B · Whitefish, MTN1258RUnderland Evageline D · Willmar, MNN1260RLife Builders International · Albert Lea, MNN1262RKullmann Richard · Encinitas, CAN1270RDunbar Stephen E Trustee · Broken Arrow, OKN1282RHoover Brian A · Warsaw, INN1283RKeyser Dakota R · Ralls, TXN1290RJones William Frank · Brea, CAN1292RHudson Mitchell C · Erie, CON1313BSwanland Robert C · San Jose, CAN1313XM & S Airsupply DBA · Hawthorne, CAN131HPrentice Robert D · Ripon, WIN13235Kimbrel Michael G · Oakville, WAN132FPendergrass Glen · Plainview, TXN165TVSwanland Robert C · Grants Pass, ORN16LSBonomo Thomas · Colorado Springs, CON18MTBaker John Bennett · Tahoka, TXN199KLWebb Phillip D · Diamondhead, MSN4974ARegistered aircraftN500AKiehl Timothy A · Glendale, AZN503AMatulewic Robert S · Alhambra, ILN505AIvy James H III · Seligman, AZN508AKimball Stephen W · Columbus, NMN510AWhite Raymond W · Montrose, MIN511ADoorenbos Rodney J · Washburn, MON515AGodlasky Charles A · Powell Butte, ORN519ALester John M · Okanogan, WAN520ALentz Blaine D · Laramie, WYN536AScgi Inc · Griffin, GAN538APontious Alfred A · Mojave, CAN540ABarnow Jeffrey W · Boulder, CON55812Heaton Timothy J · Apopka, FLN6553NBeattie Joseph D · Manitowoc, WIN6555NRobinson Thomas G · Arlington, TXN6558NDickson Bernard G · Chiloquin, ORN6560NVano Sally L · Carlos, MNN6565NPerino Joseph P Jr · Carrollton, TXN6567NSeratt Timothy G · Harviell, MON6569NSchimmel O L · Port Hueneme, CAN6575NPenney John C Trustee · Evergreen, CON6577NBartels Lance R · Freetown, INN6578NOxford Sherman D · Flower Mound, TXN6579NYork Ben III · Mesa, AZN6582NPenney John C Trustee · Evergreen, CON6587NBullock David R · Jarales, NMN6592NDe Mar David W · Corrales, NMN6596NCleis Richard A · Kihei, HIN6597NCherry Hill Aviation Inc · Freetown, IN
Back to AD 53-16-01