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.
N419ALTomahawk Aero Services LLC · Bellingham, WAN41DRMiller David E · Wheat Ridge, CON4207EDohnke Frederick William · Tehachapi, CAN4228ETomahawk 4228e LLC · Tucson, AZN4251ERobbins Warren N · Chandler, AZN4267ERmd Enterprises LLC · Rockwall, TXN4275EAllison Larry J · Villa Rica, GAN4290EAnderson Todd R · Bremerton, WAN4298EParish Matthew G · Drummonds, TNN4319EAcevedo Adriel · San Antonio, TXN4327EPegasus Enterprises LLC · Overton, NVN4330EDooley Jon S · Greensburg, INN4342EMoon Jonathan Edward · Butler, PAN4347ECarver Lloyd · Snellville, GAN4350EUrgiles Carbaca Andres A · Lantana, FLN4356EGarcia Alfonso · Lovington, NMFirst renewal noticeN4387EAlbergotti James M III · Orangeburg, SCN4432EMeyer Reed J · Moses Lake, WAN4447EFucito Daniel Ross · Lexington Park, MDN4470ETurner John C R · Broken Arrow, OKN4476EN4476e LLC · Saint Charles, MON447CTHowell Aviation LLC · Orlando, FLN44AJMyers Nathan · Clarksburg, CAN44BAKnop Horacio M · Miami, FLN464Trn Aviation LLC · Lewes, DEFirst renewal noticeN469RAChorice Kenneth · Bartlett, TNN528WAirplane Services Inc · Jay, FLN537NMasure Jason F · St Helena Is, SCN53BSAloft Technologies Inc · Maple Grove, MNN6159NCrothall George · Oceanside, CAN6204ADelong Donald E · Conyers, GAN6205ADorbzeldge Air Service LLC · Bloomfield Hills, MIN6219AVann Dudley C · Greenville, NCN6240ACraig Matthew · Peachtree City, GAN6265ALewis Albert D · Newark, OHN6266AGhaemi Mike · West Hills, CAN6289ABright James D · Clyde, NCN6290APfeifer Carol A · Victoria, KSN6309AWilliams Mike · Hartsville, INN6334ARhodes Brandon L · Woodville, TXN6397AJasinski John H · Yukon, OKN6401ALynch Rick W · Lewisburg, TNN6448ABrown Frederick A · Scottsbluff, NEN6451AAnywhere Atp LLC · Mount Juliet, TNN6467ALouise Walters Enterprises · Malabar, FLN6497AHenry Mark Alan · Dickinson, TXN673ASRodriquez Adrian · Miami, FLN764APSale Reported · Kaplan, LASale reportedN76CMRegistration Pending · New Braunfels, TXRegistration pendingN775JPWentworth Philip C II · Nashport, OH
Back to AD 80-22-13