OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N2483DBrogden Aviation LLC · Olathe, KSBuilt 1952 · S/N 20635N2483FMiller Clinton J · Traverse City, MIBuilt 1966 · S/N 18051685N2483GLenox Mark W · Idaho Falls, IDS/N 51783N2483JWestern Pilot Service Inc · Phoenix, AZBuilt 1979 · S/N 18803467TN2483QMarch Kenrick D · Kingwood, TXBuilt 1966 · S/N 18257683N2483RSkydive Twin Cities LLC · Baldwin, WIS/N 18255583N2484CLejeune Aerial Applications LLC · Basile, LABuilt 1954 · S/N 30784N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686N2484JTundra Aviation Inc · Casselton, NDBuilt 1966 · S/N 15065584N2484LLuv2fly LLC · San Antonio, TXS/N 17255684N2484UFiske James K · North Andover, MABuilt 1963 · S/N 17250084N2485DDraggin Tail Pilots LLC · Prospect, PABuilt 1952 · S/N 20637N2485GBack Country Guys LLC · Prescott, AZBuilt 1959 · S/N 51785N2485JPercival Sheila · Watson, ILS/N 15065585N2485QPayne Scott M · Twin Bridges, MTBuilt 1966 · S/N 18257685N2485SBrewer Lester A · Magna, UTS/N 337-0785N2485YMcdonald Gregory S · Mena, ARBuilt 1962 · S/N 17249785N2486CArmstrong Patrick Trustee · Bishop, CABuilt 1954 · S/N 30786N2486GDenton Bob · Nampa, IDBuilt 1959 · S/N 51786N2486RCain James W · Big Rapids, MIBuilt 1964 · S/N 18255586N2486SDarvek LLC · Las Vegas, NVBuilt 1967 · S/N 337-0786N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386N2486YCarfinder LLC · Huntington Station, NYBuilt 1962 · S/N 17249786N2487DBlue Four Aviation LLC · North Pole, AKBuilt 1952 · S/N 20639N2487GRegistration Pending · Aledo, TXRegistration pendingBuilt 1959 · S/N 51787N2487RCummings Sean · Lombard, ILBuilt 1964 · S/N 18255587N2487UBaske Scott E · Hanna, INBuilt 1963 · S/N 17250087N2487YBradley Jeff C · Schertz, TXS/N 17249787N2488DStokes David R · Sleepy Hollow, ILBuilt 1952 · S/N 20640N2488GRumley Orville C · Minco, OKBuilt 1959 · S/N 51788N2488JMcdonald Nicholas W · Phoenix, AZBuilt 1966 · S/N 15065588N2488RCorprew Gerard A · Callao, VABuilt 1964 · S/N 18255588N2488USchafer Gerhard Walter · Fairbanks, AKS/N 17250088N2488XCentral Oil Co LLC · Mcminnville, TNBuilt 1965 · S/N 18256388N2489CRegistered aircraftBuilt 1954 · S/N 30789N2489DClark Joseph F III · New Smyrna Beach, FLBuilt 1952 · S/N 20641N2489GRogers Gregory J · Plesant Hill, MOBuilt 1959 · S/N 51789N2489JVan Velson Richard Lee · Brule, NEBuilt 1966 · S/N 15065589N2489LCalifornia Aviation Services Inc · Riverside, CABuilt 1966 · S/N 17255689N2489UKauachi Melik · Brownsville, TXS/N 17250089N2489XVanderweel Martha · Wolcott, NYBuilt 1965 · S/N 18256389N248ERUnverferth Gregory T · Fort Jennings, OHS/N 17271977N248GTHansen Nelse · Lawrenceville, GABuilt 1981 · S/N 17274572N248HSLitchfield Lantz · Las Vegas, NVBuilt 1978 · S/N 21062726N248JWN248jw LLC · Sammamish, WABuilt 2023 · S/N 18283211N248RAReynolds Darryl G · Wills Point, TXBuilt 2000 · S/N 172S8562N248SFEl Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13443N248ZLightsey Aviation LLC · Jacksonville, FLBuilt 1967 · S/N 17256247N2490JSchmitt Rudy · Brookshire, TXBuilt 1966 · S/N 15065590N2490LWimberly Thomas F III · Bend, ORBuilt 1966 · S/N 17255690
Back to AD 79-10-14 R1