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.

N2369CBlackert Charles M · Delaware Water Gap, PABuilt 1954 · S/N 30669N2369DAbbott Dylan L · Lompoc, CAS/N 20521N2369GPeter Travis E · Casper, WYBuilt 1958 · S/N 51669N2369KMgm Aviation LLC · Montara, CABuilt 1998 · S/N 18280394N2369UMahoney Brandon M · Laurelville, OHS/N 17249969N2369YMischel John Patrick · Salyersville, KYBuilt 1967 · S/N 17700169N2369ZDhs Operations LLC · Wilmington, DEBuilt 1999 · S/N 17280658N236AMyotis Ltd · Leesburg, VABuilt 1973 · S/N 18262695N236AFAero Fisheries Inc · Fort Pierce, FLBuilt 1976 · S/N 17267726N236DAFalany Curtis E · Tallahassee, FLBuilt 1966 · S/N 17254466N236NYCivil Air Patrol Inc · Maxwell Afb, ALS/N 17268975N236SP83l Ventures LLC · San Carlos, CABuilt 1999 · S/N 172S8213N236TFChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 172S12134N2370DPoeppelman Philip W · Versailles, OHBuilt 1952 · S/N 20522N2370EPowers Thomas Jr · Westerly, RIS/N 18280540N2370FChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280618N2370GJ H Nicklas Inc · Cartersville, GABuilt 1958 · S/N 51670N2370JOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S10100N2370UWatts Keith R · Chapel Hill, TNBuilt 1963 · S/N 17249970N2370WSall LLC · Mill Valley, CABuilt 1998 · S/N 18280405N2371CMathers John R · Denton, TXBuilt 1953 · S/N 30671N2371ETmc Shooting Range Specialist Inc · Valencia, CAS/N 17271254N2371RBudell Stacey M · Caldwell, IDBuilt 1964 · S/N 18255471N2371XCouch Sue A · Dewy Rose, GABuilt 1965 · S/N 18256271N2372DTucker Matthew T · Dillingham, AKS/N 20524N2372GJohnson David B · Santa Barbara, CABuilt 1958 · S/N 51672N2372USky View Aviation LLC · Lenoir, NCBuilt 1962 · S/N 17249972N2372XRegistered aircraftBuilt 1965 · S/N 18256272N23735Leighton Farms Ltd · Griswold, IABuilt 1999 · S/N 18280458N2373FRlo Aviation LLC · Double Springs, ALBuilt 1965 · S/N 21058573N2373GCentral Iowa Aviation LLC · Ankeny, IABuilt 1998 · S/N 172S8073N2373KReading Aero Club Inc · Reading, PABuilt 1999 · S/N 172S8074N2373MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10592N2373UBeeline Aviation LLC · Austin, TXBuilt 1962 · S/N 17249973N2373ZN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8075N2374EN2374e LLC A Series Of Aero Lease LLC · San Antonio, TXBuilt 1999 · S/N 17280716N2374GAirco International LLC · Everett, WAS/N 51674N2374UEstes Kenneth · Benton, KSBuilt 1962 · S/N 17249974N2374XMorrison Aircraft · Harrisburg, ARS/N 18256274N23756Sweet Fred A · Loves Park, ILBuilt 1998 · S/N 18280429N2375DGauntt Chep · Goodyear, AZBuilt 1952 · S/N 20527N2375JBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280451N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257N2375XBaldwin Todd K · Prescott Valley, AZBuilt 1965 · S/N 18256275N2376GN2376g LLC · Helena, MTBuilt 1958 · S/N 51676N2376RRegistered aircraftBuilt 1999 · S/N 18280431N2376UHowell Rebecca Elizabeth · Elgin, TXBuilt 1962 · S/N 17249976N2376VPeyrot Eric M · Summerland Key, FLBuilt 1998 · S/N 18280432N2376XMueller Howard W · Winston Salem, NCBuilt 1999 · S/N 18280433N23777Erb Ralph J · Mebane, NCS/N R1720096
Back to AD 79-10-14 R1