AD 2012-17-10
Registered aircraft · 377
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-10')
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-10')
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-10') 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-10') 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.
N911RYSacramento County Sheriffs Department · Mather, CAN911SSMerced County Sheriffs Office · Merced, CAN911SZBernalillo County Sheriffs Department · Albuquerque, NMN91320Avag Inc · Richvale, CAN9151ADown East Emergency Medicine Institute · Orono, MEN918TGBell Asset Management Inc · Higley, AZN9215ZCharlie Don'T Surf Uh1 LLC · Boynton Beach, FLN92535Southwest Florida Aviation Inc · Arcadia, FLN935MFUsda Forest Service Fepp · Old Town, MEN93NDStratford Police Dept · Southport, CTN9434APennsylvania College Of Technology · Williamsport, PAN945MFUsda Forest Sercice Fepp · Old Town, MEN94NWNorthwest Helicopters I Inc · Olympia, WAN955FSTumbleweed Leasing Co Inc · Salt Lake City, UTN955MFUsda Forest Service Fepp · Old Town, MEN959BHBering Air Inc · Nome, AKN95ADBillings Flying Service LLC · Billings, MTN965MFUsda Forest Service Fepp · Old Town, MEN9678ZFlight Data Inc · Roanoke, TXN96ECAv8-Orr Helicopter Services Inc · Hamilton, MTN97NWNorthwest Helicopters LLC · Olympia, WAN987SFUsda Forest Service Fepp · Minden, NVN98FPrescott Gordon F · Princeton, WVFirst renewal noticeN99021Magnum Aviation LLC · Goff, KSN990PSUh 1 LLC · Fort Lauderdale, FLN99478Vf99478 LLC · Wilmington, DEN99675Alaska Remote Outfitters LLC · Kenai, AK
Back to AD 2012-17-10