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.
N6861RJohnson Bradley Michael · Belgrade, MTN6862EBostik Industries LLC · Green Cove Springs, FLN6862FGradel Thomas A Jr · Irmo, SCN6862HStrickland J A · Fairbanks, AKN6862MCreacy Jason Thomas · Gatesville, TXN68639Bathalter Michelle N · Las Vegas, NVN6863AZinter Dean K · Tigard, ORN6863MRvandco LLC · Missoula, MTN6863TBering Capital LLC · Anchorage, AKN6864ABrusik John A Jr DBA · New Port Richey, FLN6864HMay Jeffrey N · Ocala, FLN6864MKnott Dustin Shane · Brentwood, CAN6864RRankin Bryan · Cloverdale, CAN6865ESustek Jerry · Seattle, WAN6865FGeissler Robert William Jr · Baltimore, MDN6865XGessley Lester Jack Jr · Port Saint Lucie, FLN68662Edwards Joseph C Trustee · Austin, ARN6866AJlk Inc · Malvern, ARN6866EStuart Bradley J · Hillsboro, NDN6866FLand Ross A · Cedar Rapids, IAN6866HParrish Michael C Trustee · Lakeland, FLN6866ROrnes W Harold · Aiken, SCN6867AHeffron Jacob L · Little Falls, MNN6868FVan Bielert Wouter · Haxtun, CON6868LJohnson Gregory L · Orange, CAN6868RChrisman Charles Griggs · Denver, CON6868XRegistered aircraftN6869AMccraney John K · Canon, GAN6869TCsa Aircraft Leasing LLC · Salt Lake City, UTN6869XSquires Aaron Lane · Aynor, SCN686DBAnderson Bruce Robert · Mena, ARN686DWSunrise Aviation Inc · Ormond Beach, FLN686MGMike Golf Holdings LLC · Pinellas Park, FLN686PXTextron Aviation Employees Flying Club Inc · Wichita, KSN686SPRainier Flight Service LLC · Renton, WAN6870ELentfer Sheryl A · Anchorage, AKN6870LBarr Air Patrol LLC · Mesquite, TXN6870MApplied Science Services Corp · Woodland Hills, CAN6871AGibson James G · Harpers Ferry, WVN6872ACoats Alexander · Murrieta, CAN6872FSkybound Aircraft LLC · Blue Point, NYN6872GVortex Aircrafts Inc · Port Saint Lucie, FLN6872MShowalter Mark W · Richland, WAN6873EWallace Joseph R · Winchester, KYN6874AGillum Thomas W III · Davenport, IAN6875EElston Josh · Sterling, AKN6875GStevenson Mark Frank · Anthem, AZN6876EDunn Gary K · Paw Paw, ILN6876FPalmer Dana G · Gatesville, TXN6876GMyers Russell E · Happy Jack, AZ
Back to AD 79-10-14 R1