Skip to content

Registered aircraft · 56,580

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

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

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.

N42485Kaiser Enterprises Inc · Carrollton, MOBuilt 1968 · S/N 18259036 N42486Armstrong Kevin L · Corvallis, ORBuilt 1973 · S/N 18052357 N4248FWilcox Ross P · Newark, DEBuilt 1958 · S/N 46148 N4248LOney Marilyn S · Beach City, OHBuilt 1970 · S/N 18260226 N4248QPhysics Aviation LLC · Jonesboro, ARBuilt 1971 · S/N 17260148 N4248UEyles Benson G · Hampden, MEBuilt 1963 · S/N 15060248 N42492Mcdermott Brian D · Fairbanks, AKBuilt 1968 · S/N 18259042 N4249LKraus Gary L · Holbrook, PABuilt 1966 · S/N 17254318 N424ADSky West Aviation Inc Trustee · Albuquerque, NMS/N 20700337 N424BCPikeside Flying Club Inc · Martinsburg, WVBuilt 1964 · S/N 17252171 N424CBLesnett Robert G · Novato, CABuilt 1968 · S/N 18258975 N424DDMaple Aviation LLC · Big Fork, MTBuilt 1972 · S/N 18261424 N424EChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11448 N424NTLattin Travis · Beloit, KSBuilt 1957 · S/N 34555 N424PEUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2017 · S/N 172S12058 N424PSRegistered aircraftBuilt 1958 · S/N 51295 N424RCLatshaw Bonnie Stewart Trustee · Tulsa, OKS/N 18504071 N424RESipe Scott W · Georgetown, DES/N 17275599 N424SCThread Head Quilting LLC · Anchorage, AKBuilt 1975 · S/N 17702367 N424STMisto Louis III · Westerly, RIBuilt 2005 · S/N 18281739 N424TRCovin Equipment LLC · Arlington, TXBuilt 2005 · S/N 18281562 N424WSkywarrior Flight Training LLC · Pensacola, FLBuilt 1982 · S/N 17275579 N424WMMorrison Jeffrey A · Williamson, GABuilt 1977 · S/N 17269385 N42504Dent Michael Otha · Lake Wylie, SCBuilt 1968 · S/N 18259045 N4250LKnight Aire LLC · Simpsonville, SCBuilt 1966 · S/N 17254319 N4250QTice Evan L · Seattle, WABuilt 1971 · S/N 17260150 N4250UBrownfield Bruce · Oak Park, CABuilt 1963 · S/N 15060250 N4250VSnyder Michael Scott · Erie, COBuilt 1948 · S/N 18606 N42510Skylane 42510 LLC · Moses Lake, WABuilt 1968 · S/N 18259048 N42514Tillison Michael W · Cameron Park, CABuilt 1968 · S/N 18259049 N42518Thomas Raymond N · Springfield, SDBuilt 1968 · S/N 18259052 N42519Cruse Chancy Q · Clarendon, TXBuilt 1968 · S/N 18259053 N42520R & D Aero LLC · Midlothian, TXBuilt 1968 · S/N 18259054 N42521Coutrney Joseph · Livingston, LAS/N 18259055 N42525Titus Daniel A · Batavia, OHBuilt 1968 · S/N 18259056 N42526Stanley Gerald L · Littleton, COBuilt 1973 · S/N 18052359 N4252FLunn James · Winchester, CAS/N 172RG0644 N4252LStephani Timothy M · White Lake, WIBuilt 1966 · S/N 17254321 N4252V212 Investments Of Montana LLC · Owasso, OKBuilt 1948 · S/N 18608 N42536N B B S LLC · Kansas City, KSBuilt 1973 · S/N 18052360 N42538Walled Lake Flying Club · Waterford, MIBuilt 1968 · S/N 18259064 N42539Lincoln Sport Parachute Club Inc · Lincoln, NEBuilt 1968 · S/N 18259065 N4253QFrog Av LLC · Brownstown, INBuilt 1971 · S/N 17260153 N4253UConrad Chace D · Maryville, TNBuilt 1963 · S/N 15060253 N42543Browne Hunter J · Woodacre, CABuilt 1968 · S/N 18259069 N42546Hogue Patrick L · Paso Robles, CABuilt 1968 · S/N 18259070 N42549Schutz Christopher J · Rock Springs, WYBuilt 1968 · S/N 18259072 N4254FRed Baron LLC · Davis City, IABuilt 1958 · S/N 46154 N4254VJohnston Daniel T · Cambridge, OHBuilt 1948 · S/N 18610 N42550Byerley Mark S · Greenback, TNBuilt 1968 · S/N 18259073

Back to AD 79-10-14 R1