AD 80-22-13
Registered aircraft · 442
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:80-22-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:80-22-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:80-22-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:80-22-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.
N2494BMunger Steven D · Mifflintown, PAN2495APhillipine Matthew · Bonita Springs, FLN2495DGutierrez Roberto R Jr · Edinburg, TXN2498DGenzlinger Chad A · Foresthill, CAN2499AEhrich Anthony K · Rockham, SDN2499PPancio Paul · Lagrangeville, NYN2500ERudloff Uwe K Trustee · Lake Village, INN25023Linero Jose J · San Juan, PRN2503PAlpha Aviation Holdings Group LLC · Raleigh, NCN2503VAlpha Aviation Holdings Group LLC · Raleigh, NCN2505KIvy James E · Alba, TXN25062Stratton James P · Lubbock, TXN2506GInternational Air Services Inc Trustee · Carson City, NVN2506LColumbus State Community College · Columbus, OHN2507AMann Robert M · Royal Oak, MIN2507DMurphy Robert Joseph · Galveston, TXN2507PSailor Dog Aviation LLC · Portland, ORN25091Piper Aircraft Inc · Vero Beach, FLN2509AEagle Aviation LLC · Benton, KYN2512LHartsock Jane R · Laurens, IAN2512NArias Kevin · Cheverly, MDN25137Piper Aircraft Inc · Vero Beach, FLN2513AHarris Alden F · Shrewsbury, MAN25140Piper Aircraft Inc · Vero Beach, FLN2516BPearlsnap Solutions LLC · Georgetown, TXN2516CStrong Don E Jr · Mountain Home, ARN2517BJobe Dwaine B · Chilhowee, MON2518LKerber John · Decorah, IAN2520ARaptor Flight LLC · Fort Worth, TXN2520BRegistration Pending · Cheshire, CTRegistration pendingN2522CKlamecki Alan P · Phoenix, AZN2523BJenny Joe S · Fresno, CAN25252Scott Wilson A · Norman, OKN2525BOn Course LLC · Saint Charles, MON25287Greenwood John R · Bellevue, NEN2528BMankowski Luke Ray · Granbury, TXN2529VPiper Aircraft Inc · Vero Beach, FLN2530NGibbs Robert I · Ravenswood, WVN2531ATyler Jeffery Jack · Anchor Point, AKN25340Resetich Michael J · Gravois Mills, MON2536AA & J Air Sales Inc · San Antonio, TXN2537DBurdette William E · Corpus Christi, TXN2538ARegistration Pending · Sheridan, WYRegistration pendingN2539BRegistered aircraftN2539GTpt Aviation LLC · Caseville, MIN2540CSpeidel Jake P · Carmel, CAN25410Smith Ira · Henderson, NVN2547DFinley Charles Marcus · Reno, NVN2548BHard Landing LLC · Fort Pierce, FLN2548CSunrise Aviation Inc · Ormond Beach, FL
Back to AD 80-22-13