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.
N9448TSanders Robert · Harlingen, TXN9451TRegistration Pending · Austin, TXRegistration pendingN9459TAdventures In The Sky Aviation LLC · Fresno, CAN9475TJohnson Marc · Westland, MIN9479TSouthern Colorado Flight Professionals LLC · Pueblo, CON9482TReid John · Emmett, IDN9483TLindley Mark E · Wakefield, RIN9504TWilloughby Dan J · Linden, MIN9514TColl Valdes Jeffrey A · Boise, IDN9525TPorte Elvis · Miami, FLN9547TJk Gray Family LLC · Concord, NCN9549TWilliams Dan John · Phoenix, AZN9559TGlanz William L · Central, AKN9563TStone Michael S · Chamois, MON956RWTrevitue LLC · San Antonio, TXN95SWMayer Cynthia Lynn · Ponce Inlet, FLN9615TEtzel Gregory J · Lafayette, INN9627TRegistration Pending · Sunny Isles Beach, FLRegistration pendingN9639TBasinger Kenneth J · Mcdonough, GAN9651TPilot Pros Inc · Miami, FLN9674TMichael Guetersloh · Sandia, TXN9695TCavallaro Marco · Amarillo, TXN9717TLehmann Peter E · Pembroke, MEN9737TBayview Flying Club LLC · Milwaukee, WIFirst renewal noticeN9741TLitchfield Flying Club Inc · Litchfield, MNN9757TDevevo Warren C Sr · Sylvania, GAN9763TBiotech Vending LLC · Escondido, CAN9771TTrevisan Hugo S · Polk City, FLN9775TDawson John D · Garland, TXN9811TAnywhere Atp LLC · Mount Juliet, TNN9842THahn John C · Sherwood, ARN9873TMaycock David V · Hurricane, UTN9906TRausch Henry J · Harpers Ferry, WVN9912TLang Robert H · Pittsburgh, PAN9915TRobinson Christopher Cody · Richmond, KYN9916TRogers Greg · Las Vegas, NVN9972TOliver Randy Martin · Kent, WAN9973TMenno David L · Lancaster, NYN9974TArgos Retail LLC · Mcallen, TXN9976TAlvarez Humberto H · Kingsville, TXN9978TMaletich Dustin S · Pilot Rock, ORN9981TLadegard Paul E · Wasilla, AK
Back to AD 80-22-13