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.
N7715AWallace Wayne P · Graham, WAN7715GAirborne LLC · Wilmington, DEN7715KDutch Air LLC · Kalispell, MTN7715UFenton Dale R · New Bern, NCN7716GFirst Eclipse Ltd · Richmond, VAN7716UOpportune Entity LLC · Sanger, TXN77177Nazario Caleb R · Orlando, FLN7717AMcclelland Jacob D · Fairfield, CAN7717GJohnson Eric C · Turtle Lake, NDN7717TGully Samuel Lee · Noxapater, MSN7717UGreen Castle Aero Club Ltd · Oxford, IAN77182Magro Daniel L Sr · Piperton, TNN77185Carter Danny · Baxley, GAN7718EHeuser Timothy J · Cottage Grove, ORN7718FAdams Aviation Services Inc Trustee · Wilmington, DEN7718URenninger Dustin L · Mc Veytown, PAN7719EOlson Ben A · Gig Harbor, WAN7719TRushton George Emery · Clinton, MIN771CPCivil Air Patrol · Maxwell Afb, ALN771DCTlh Enterprises Inc · Corsicana, TXN771EEBtr Inc · Chula Vista, CAN771KKnutson Aviation Inc · Cedar Hill, TXN771KCAkin John · Highland, CAN771PMaxq Composites LLC · Oxford, MEN771SMGilbreath Tony C DBA · Olustee, OKN771TMMid-South Aviation LLC · Caruthersville, MON771XRanney Dorothy Gayle · Cordova, AKN77206Venture Alaska LLC · Homer, AKN7720AKrueger Eric J · Olivehurst, CAN7720EAircraft Systems Group Inc · Odessa, FLN7720GZulu Jets LLC · Boerne, TXN7720XJeter Thomas L · South Padre Island, TXN7721AAngel Steven · Fairbanks, AKN7721GWurtsboro Airpark LLC · Wurtsboro, NYN7721TBourdon Alain · West Springfield, MAN77222Davis Sam Alan · Wendell, NCN7722FSmall Tony D · Welch, OKN7722GKnaack Roland · Cumming, GAN7722TPfc Aviation Repair Inc · Wallingford, CTN7722UBeebout Shawn C · Milroy, MNN7722XLeasure Everett D · Joliet, ILN7723ADoremus Scott M · Wolfeboro, NHN7723FSchlueter Rodney E · Kansas City, MON7723MDdw Inc · Gardner, CON7723UAdams David C · Westford, MAN7724GWind Walker LLC · Tucson, AZN7724KGardner Thomas W · Lincoln, MEN7724XJohnson Randy G · Collinsville, OKN7725FToney Michael · Saint Peters, MON7725UCvz-Vivace LLC · Fort Worth, TX
Back to AD 79-10-14 R1