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.
N77XZRed Rocket Holding Co LLC · Boca Raton, FLN7803ESterling Paul M · Goodyear, AZN7803QSterling Paul M · Goodyear, AZN78WSHjelmstad David J · Burnsville, MNN791DSPlane Fun Inc Tr Trustee · Snellville, GAN7QJDeremer Eric B · Kissimmee, FLN8479KMeidinger Vernon J · Zeeland, NDN8573XSale Reported · North Royalton, OHSale reportedN874MHLantana Pfz LLC · Palm Springs, FLN888KCGrimes Joshua R · Lock Haven, PAN9080YGorley Raymond W · Lees Summit, MON91315Kearley Greg A · Lafayette, LAN91319Bas Part Sales LLC · Greeley, CON91325Korenko Kirk A · Granite Bay, CAN91332T-32 Associates · Effort, PAN91341Wheeler Shaun W · Covington, TNN91372Higgins Robert S · Granbury, TXN91383Rieder Josh · Boone, NCN91386Shred Box LLC · Hayesville, NCN91414Richardson James R · Brandon, MSN91544Piper Aircraft Inc · Vero Beach, FLN9182AAlpha Aviation Holdings Group LLC · Raleigh, NCN9199AArgos Retail LLC · Mcallen, TXN9209AAerospace Trust Management LLC Trustee · Wilmington, DEN9214ATerhune Larry W · Saginaw, TXN9216TLudwigson Joel · Inver Grove Hts, MNN92258Mendez Leonel Jr · Corpus Christi, TXN9237TVann Dudley C DBA · Greenville, NCN924SAGiber Sharon G · New Port Richey, FLN9266TCrosswind Aviation Inc · Oakley, KSN9268TRooney James J · Friendswood, TXN9275TMoore Joseph P · Stillwater, OKN9278TSanderson Nicholas DBA · Olivet, MIN9284TGarrett Randall F · Fort Walton Beach, FLN9290TWings Flight Enterprises Inc · Danville, KYN92BASprott Robert L · Perkins, OKN9304TPiper Aircraft Inc · Vero Beach, FLN9314TGriffith Stephen P · Merritt Island, FLN9318TGuerra Eduardo · Polk City, FLN931SCActiveair LLC · Erie, PAN9327TFlener Stephen J · Sterling, OHN9341TWilliams Norman L · Ennis, TXN9351TBenson Michael W · Julesburg, CON9358TPitts Lynn Larry · Webb City, MON9369TTarno Suzzan G · Avondale, AZN9376TMosley Kenneth N · Westlake Village, CAN9387TAnczarski John J · Ringtown, PAN9394TRiepe Andrew P · Rossier City, LAN9411TLopez Geo U · Round Rock, TXN9431TDavis Gary L · Burleson, TX
Back to AD 80-22-13