AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N50434Summerville Daniel · Millersville, MDN50438Roche Thomas A · Bardstown, KYN5043AStephens Zachary L · Big Lake, AKN5043JValiair Lc Trustee · Casper, WYN5043RRegistered aircraftN5044APatzanakidis Konstandinos · Jupiter, FLN5044DCarpenter Corey · Warden, WAN5044EAviation Needs LLC · Stapleton, NEN5044HCoogan Dennis P · Madison, WIN5044RSouth Bay Flight Training Center · Carolina, PRN50457Odyssey Entertainment Inc · Crystal, MNN5045HGrabofsky Livestock & Grain Inc · Hogeland, MTN50462Weekley Clint · Manvel, TXN50465Howard Wayne A · Loon Lake, WAN50467Hastings Stephen J · Palmer, AKN5046AHappy Landings Aviation LLC · Maple, NCN5046RSandpoint Aviation LLC · Sandpoint, IDN50471Honsperger Karl J Trustee · Fremont, OHN50473Cobrinik Adam · Whites Creek, TNN50474Mother Lode Flying Club · San Andreas, CAN50475Mc Ironworks Welding And Fabrication Inc · Chico, CAN50479Alvarez Randolph Clarence · Igiugig, AKN5047AAeroslat4 LLC · Lewes, DEN5047DMarler Don T · Pocatello, IDN50484Freudenthal Jack J · Medford, WIN50485Wiedeman Douglas J · Springboro, OHN50488Fratti Robert B · Nampa, IDN5048RSandeep Sharma LLC · Oshkosh, WIN5048VLoewen Wielhelm · Presidio, TXN50497Meurer Carl J · Little Rock, ARN5049RIndiana Paging Network Inc · La Porte, INN504EAOlympic Jet Inc · Olympia, WAN504FAClow International Airport LLC · Bolingbrook, ILN504JRitter Michael W · Cumberland, MDN504JCFrequent Flyer LLC · Manasquan, NJN504JJEdwards William A · Midland, GAN504JWPalmer Gary H · San Juan, TXN504MAEastern Kentucky University · Richmond, KYN504QChelatna Lake Lodge LLC · Anchorage, AKN504SDPate Charles C Trustee · Wichita, KSN50502Behnke Randall · Manitowoc, WIN50503Kelly Keith Austin · Oklahoma City, OKN50504Baker Merlin K · Bradford, OHN5050ACampbell Barry A · Rogersville, TNN5051DVincent Wendal J · Geismar, LAN5051RSkywarrior Flight Training LLC · Pensacola, FLN50523Koch Allen William · Anchorage, AKN5052DFertic Knute · Oklahoma City, OKN50530Kelly John M · Gastonia, NCN50531Davies Patrick R · Trussville, AL
Back to AD 79-10-14 R1