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.

N6285SWindsor John R · East New Market, MDBuilt 1967 · S/N 15067085N6285TReasner David S · Moultonborough, NHBuilt 1964 · S/N 15060985N62862Freeflight Aviation LLC · Allentown, NJBuilt 1981 · S/N 17275343N6286SCunningham Doris DBA · East Freetown, MABuilt 1967 · S/N 15067086N62875L&W Leasing LLC · Smyrna, TNBuilt 2008 · S/N 172S10756N62876American Patrols Inc · Midland, TXS/N 17275346N6287ARespess William Wallace III · Summerland Key, FLS/N 33087N6287EClemons Martin · Butte, MTS/N 46387N6287GPeters Guy P · Roy, UTBuilt 1970 · S/N 15071787N6287KWilliams Jimmy Z · Sherman, TXBuilt 1975 · S/N 15077625N62887Carter Jeffrey P · Parker, COBuilt 1981 · S/N 17275350N6288AMartin Joshua Keith · Rifle, COBuilt 1956 · S/N 33088N6288DRickwalt David L · Fort Mohave, AZS/N 17272694N6288EMccardy Derk · Torrance, CABuilt 1959 · S/N 46388N6288FAircraft Leasing And Service · Malabar, FLBuilt 1965 · S/N 337-0288N6288GFetter Stanley B · Accokeek, MDBuilt 1970 · S/N 15071788N6288KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N 15077626N6288TGrote Bradley J · Torrington, WYBuilt 1964 · S/N 15060988N62890Fixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1981 · S/N 17275351N62891Wings Over Texas Holdings LLC · Denton, TXS/N 17275352N6289DYecny Enterprises Inc · San Luis Obispo, CABuilt 1979 · S/N 17272695N6289EMaverick Jets LLC · Vineburg, CABuilt 1959 · S/N 46389N6289FSbk Aviation LLC · Festus, MOBuilt 1979 · S/N 17273181N6289KPitcock Randall · Farwell, TXBuilt 1975 · S/N 15077627N6289SLink Darryl B · Centennial, COBuilt 1967 · S/N 15067089N628CTAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12897N628DKEastgate Investments LLC · Henderson, NVBuilt 1965 · S/N 18255786N628FNFlying Neutrons LLC · Lebanon, OHBuilt 1998 · S/N 18280227N628JCDelaney Patrick James · Marion, TXBuilt 1974 · S/N 17262911N628LAAircraft Holdings LLC · Scottsdale, AZBuilt 2024 · S/N 172S13126N628MAFitzgerald Brian B · Gettysburg, PABuilt 1964 · S/N 15060912N628PDMessimer Joseph L Jr · Nacogdoches, TXBuilt 2000 · S/N 18280724N628RBBrown Michael C · Erie, KSBuilt 1972 · S/N 17260622N628RGKozubek Richard R · Shady Shores, TXBuilt 1976 · S/N 177RG0992N628TTTollen Troy J · Austin, TXBuilt 1978 · S/N 21063058N628YTAdventist World Aviation · Wilson, NCBuilt 1977 · S/N U20603816N62901Bates Field Aero Club Inc · Mobile, ALBuilt 1981 · S/N 17275355N6290EConnell Mark Stephen · Melbourne, FLBuilt 1959 · S/N 46390N6290SFloyd Brannon A · Athens, GABuilt 1967 · S/N 15067090N6290TLittlefield Molly F · Kent, WABuilt 1964 · S/N 15060990N6290VDelta Sierra Aviation LLC · White Salmon, WABuilt 1980 · S/N 172RG0610N62918Neron II LLC · New Smyrna Beach, FLS/N 17275359N6291CSatl Ranch Aviation LLC · Midland, TXBuilt 1980 · S/N 21063857N6291EWright Robert D Trustee · Redding, CABuilt 1983 · S/N 18268357N6291GWaddell Lucas A · Fort Worth, TXBuilt 1970 · S/N 15071791N6292ELucci Giacinto A Jr · Nashville, MIS/N 46392N6292RHynes Kevin P · Wichita Falls, TXBuilt 1979 · S/N 172RG0152N6292SAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1967 · S/N 15067092N6292TLee Bryan L · Salinas, CABuilt 1964 · S/N 15060992N62938Two Guys Aviation LLC · Idaho Falls, IDBuilt 1981 · S/N 17275361
Back to AD 79-10-14 R1