AD 2012-17-06
Registered aircraft · 2,157
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:2012-17-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-17-06')
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:2012-17-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-17-06') 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.
N5243PR & O Aviation LLC · Middleville, MIN5246PYoyodyne Group Inc · Wilmington, DEN5248PKnox Edward R · Gulfport, MSN5251PTaflinger Bradley P · Clarkdale, AZN5252PBrannan Andrew · Texarkana, ARN5253PSale Reported · Greeley, COSale reported, pending cancellationN5257PAero Nautics Inc · Cheyenne, WYN5258PMosley Hardy · Elko, NVN5259PPacheco Carlos Antonio · Yuma, AZN525JFMoray Eel LLC · Vail, AZN5261PMon-Dak Consulting Inc · Plentywood, MTFirst renewal noticeN5264PBohmer James F · Tulsa, OKN5272PBombach James · Katy, TXN5273PSouthern View Energy Inc · Lula, GAN5278PRoebuck David M · Hamilton, GAN5281PNardini Michael A · Dayton, OHN5283PGomes Andrew Jose · Arlington, TXN5287PFogleman Brian L · Stonewall, LAN5289PVaughan Michael P · Northbridge, MAN5290PRegistered aircraftN5291PBlack Randall D · Goodyear, AZN5292PBrooksby Blake L · Pahrump, NVN5296PFlanagan Robert Howard · Willows, CAN5297PMoretti Anthony · Deming, NMN5298PCroasdale Terry Lee · Modesto, CAN5302PFarnsworth David · Evergreen, CON5303PLuffman Michael E · Danville, VAN5305PMetzler Kevin W · Rosamond, CAN5307PDaniels Kevin · Bellingham, MAN5309PJabalera Josh M · Billings, MTN5311PAbel John A · Las Vegas, NVN5312PMalolo LLC · San Luis Obispo, CAN5313PSouthwest Aerial LLC · Bowman, NDN5315PChrystal Bluebird LLC · Valley Center, KSN5316PBrooks D Craig · Menifee, CAN5327PPowell Larry C · Fresno, CAN5329PSpectrum Communications Inc · Moses Lake, WAN5330PNielson Rex W · Pendleton, ORN5332PLarsen Joseph · Pittsburgh, PAN5333PMilligan David B · Russellville, ARN5340PDejulio Jan A · Temecula, CAN5346PBelt David Jr · White Hall, MDN5348PPari Aviation LLC · Marion, TXN5352BRegistered aircraftN5358PWilliams George A · Bonifay, FLN5359PPanhandle Groundwater Conservation District · White Deer, TXN5360PN5360p LLC · Blacklick, OHN5365PLarsen Roy E · Placerville, CAN5366PGreenlaw Russell C · Livermore, CAN5368PHeck Paul A · Santa Rosa, CA
Back to AD 2012-17-06