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.

N199GFogelson Robert A · Benton City, WABuilt 1959 · S/N 52233N199LPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 17264143N199MCFly N199mc LLC · Nevada City, CABuilt 1977 · S/N 17268570N199NLees Larry J · Pryor, OKBuilt 1986 · S/N 18268548N199PDCity Of Sacramento · Sacramento, CABuilt 1979 · S/N R1723127N199RAN199ra LLC · Huntington Woods, MIBuilt 1999 · S/N 18280636N199RFBravo Charlie Global LLC · Kalispell, MTBuilt 1979 · S/N 18266816N199RNWestern Flying Club Inc · Burlington, NCBuilt 1977 · S/N 18266079N199SHPrecision Design Inc · Wilmington, DEBuilt 2008 · S/N 18282078N199SPW Air LLC · Wheeling, ILBuilt 2003 · S/N 172S9467N199YCKruse Adam L · Weiser, IDBuilt 1976 · S/N 18258424N19AJBayshore Aircraft LLC · Miami, FLBuilt 1979 · S/N 18267286N19DEchelon Right LLC · Nicholasville, KYBuilt 1980 · S/N 18504097N19DKRichardson Cotton Inc · Wilmington, DEBuilt 2015 · S/N 18282374N19ECSerra Decca Company LLC · Seattle, WABuilt 1967 · S/N 185-1306N19EZAir Mobile Ministries · Sneedville, TNBuilt 1970 · S/N 33701315N19FABrown Brian T · Wilton, CABuilt 1961 · S/N 18253809N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668N19GCarlton Steve W · Lewiston, IDBuilt 1963 · S/N 18254596N19GCKobaly Jason D · Yucca Valley, CABuilt 1972 · S/N 18261280N19HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2003 · S/N 18281266N19HRJernigan Michael G · Toledo, ORBuilt 1966 · S/N 17255607N19JGImmeyer Daniel O · Redmond, WABuilt 1958 · S/N 55131N19JKA P Air LLC · Wilmington, NCBuilt 1973 · S/N 17701867N19JRKyle Agne · Greensboro, NCBuilt 1973 · S/N 177RG-0314N19KHVan Bortel Aircraft Inc · Arlington, TXS/N 18282073N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705N19LVLeon Ruben D · Oviedo, FLBuilt 1972 · S/N P3370012N19MJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N U20605372N19MUGarrett Jack H · Grandview, TXS/N 177RG0099N19MVSky Path Aviation LLC · Sheridan, WYBuilt 2019 · S/N 172S12273N19NJN19nj LLC · Manassas, VABuilt 1985 · S/N 17276343N19PLively Gregory · Corinth, TXBuilt 1969 · S/N 337-1091N19PFTac'S Enterprise LLC · Ballston Lake, NYBuilt 1972 · S/N 17701711N19SBMcginnis Randall E · Redding, CABuilt 1972 · S/N P3370018N19TAFun Flyers LLC · Salem, ORBuilt 1973 · S/N 17701912N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629N19TWDougherty Peter I · Orchard Park, NYBuilt 1953 · S/N 30119N19WSHolcomb Nicholas A · Yakutat, AKS/N 29689N19ZBBruton Kevin L · Roseburg, ORBuilt 1959 · S/N 55732N1AXEdgerton Agency Inc · Galena, OHBuilt 1960 · S/N 47418N1BPPatton Ministries · Grand Rapids, MNBuilt 1961 · S/N 18253260N1CTTre Aviation Corp · Queen Creek, AZBuilt 1972 · S/N P3370001N1DZXtreme Flying Services LLC · Gansevoort, NYBuilt 1961 · S/N 18253742N1EHandschiegel Robert J · Hampshire, ILBuilt 1976 · S/N 17267046N1FHBuermann Henry · Brookfield, VTS/N 18052817N1GXOclair Carleton Brent · Saco, MEBuilt 1973 · S/N 17702009N1HUCaster-Way LLC · Sebring, FLBuilt 1968 · S/N 337-1008N1JHHolden James E · Las Vegas, NVBuilt 1975 · S/N 17265723N1JYRicks Electric Plus LLC · Middleton, IDBuilt 1958 · S/N 51474
Back to AD 79-10-14 R1