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.
N742TWTumbleweed Leasing Co Inc · Salt Lake City, UTN7430ANeilsen Lorenzo I · Wilmington, NCN7430EBallesteros Irlena · Glendale, CAN7430QFlying Paws Aviation LLC · Louisville, CON7431AAero Care Inc · Orange, MAN7431EGeyer Austin D · Minot, NDN7431MWestern Pacific Systems Inc · Anchorage, AKN7431NWe Fly LLC · Fort Payne, ALN7431TKorinko Seana L · Rostraver Township, PAN7431XVannier Aviation LLC · Sheridan, ORN7432GNichols Roy D · Cadillac, MIN7432NJensen David F · Clarks Grove, MNN7432QWatkins Daniel L · Fuquay Varina, NCN7432SAnderson Jeffery G · Calhoun, LAN7432TWilcox Joshua · Mesa, AZN7432XFerguson Mark G · Wallkill, NYN7433ASmith Larry D · Friendswood, TXN7433GStyles Brian P · Cullman, ALN7433NFixed Gear LLC · Sherwood, ARN7433TAndreatta Susan J · Canon City, CON7434QD'Ambrosia Louis E · Chardon, OHN7434TDixon Farm · Tribune, KSN7435NPieretti George L · Sacramento, CAN7435TJohnson Scott E · Wausau, WIN7435XRoduner Cindy J · Benton, KSN7436EFreedom Airforce · Albuquerque, NMN7436GChickadee Aviation LLC · Rangeley, MEN7436QStefanowicz Chester J · Baltimore, MDN7437NSundance Aero LLC · Mertzon, TXN7438AKellogg Charlie H · Oxnard, CAN7438EWalker Jim O · Lovell, WYN7438GMcguinnis Joseph G · Scottsdale, AZN7438NMockler Sarah Margaret · Awendaw, SCN7439AAlsterlind Stephen W · San Rafael, CAN7439GScheck Doug J · Medina, OHN7439MBrooks Randall L · Queen Creek, AZN7439QSpoer Jonathan M · Agoura Hills, CAN743ASA2g International LLC · San Juan Capo, CAN743CPCivil Air Patrol · Naxwell Afb, ALN743HLanoue Edgar A · Stevensville, MTN743KSBarrett Buford L · Bristol, VAN743RBBenefield Shelby · Attalla, ALN743SPSilverhawk Aviation Academy LLC · Caldwell, IDN743THMike Smith Aviation International Inc · Napa, CAN743TWTumbleweed Leasing Co Inc · Salt Lake City, UTN7440AN7440a LLC · Howell, MIN7440EWilson Colton M · Wellsville, UTN7440GJohnes Charles H · Santa Maria, CAN7440MAustin Kevin · Roseville, CAN7440NDrewes Farms Inc · Craig, MO
Back to AD 79-10-14 R1