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.

N3613CSchneiderhan Edward F · Laurium, MIS/N 31111 N3613JBatista Brasil Vagner · Orlando, FLBuilt 1966 · S/N 15064913 N3613SMccomb Charles D · Cypress, TXBuilt 1963 · S/N 17250813 N3613UN3613u LLC · Lakeland, FLBuilt 1963 · S/N 18255013 N3614JSikveland Beau D · Circle, MTBuilt 1966 · S/N 15064914 N3614LHarris Danny R · Winnsboro, TXBuilt 1965 · S/N 17253783 N3614UT Yowonske Enterprises LLC · Rostraver Township, PAS/N 18255014 N3614YEmission -Air Inc · Lexington, NCBuilt 1962 · S/N 21058114 N3615CMarkwardt Jacquelyn K · Santa Cruz, CABuilt 1954 · S/N 31113 N3615LEynon Thomas Elliott · North Royalton, OHS/N 17253784 N3615SBlacqjacq Aviation Co · Wilmington, DEBuilt 1963 · S/N 17250815 N3616JB&R Aircraft LLC · Wadsworth, OHBuilt 1966 · S/N 15064916 N3616LSoflair Aviation Solutions LLC · Miami, FLS/N 17253785 N3616SArtisan Outreach LLC · Dunnellon, FLBuilt 1964 · S/N 17250816 N3616UHatch Koay A · Gilbert, AZBuilt 1963 · S/N 18255016 N3616YAnderson Dana R · Redding, CABuilt 1962 · S/N 21058116 N3617JShowalter Steven L · Goshen, INBuilt 1966 · S/N 15064917 N3617YSchindele Micheal D · Tolna, NDBuilt 1962 · S/N 21058117 N3618JWright David G · Lake Oswego, ORBuilt 1966 · S/N 15064918 N3619CHamby Michael R · Parma, IDBuilt 1954 · S/N 31117 N3619SFitch Aviation Holdings LLC · Pottsboro, TXBuilt 1963 · S/N 17250819 N3619YWilliams Jimmy Z · Sherman, TXBuilt 1962 · S/N 21058119 N361CCSackman Robert B · Unionville, INBuilt 1961 · S/N 17248703 N361CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8840 N361DBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282245 N361DCSky West Aviation Inc Trustee · Albuquerque, NMS/N U20605584 N361ESGrady Paul D · Reno, NVBuilt 1997 · S/N 17280011 N361GAGlidewell Aviation Inc · Parkland, FLBuilt 2003 · S/N 172S9521 N361LRegistered aircraftBuilt 2004 · S/N 172S9569 N361LULewis University · Romeoville, ILBuilt 2020 · S/N 172S12564 N361RHDerdak Stephen · San Antonio, TXBuilt 1956 · S/N 29013 N361TEBald Knoll Aviation LLC · Cliff, NMBuilt 1998 · S/N 18280162 N361TKReckless Air LLC · Greenback, TNBuilt 2019 · S/N 18283085 N361XSorley Steven J · Roy, UTBuilt 1957 · S/N 36238 N3620JBerens Eric A · Stevens Point, WIBuilt 1966 · S/N 15064920 N3620LMullins Lawrence D · Germantown, OHBuilt 1965 · S/N 17253789 N3620SBoese Howard · Brownell, KSBuilt 1963 · S/N 17250820 N36213N36213 Aircraft Ownership LLC · The Woodlands, TXBuilt 1975 · S/N 17702240 N3621JLow Cost Flying LLC · Chandler, AZBuilt 1966 · S/N 15064921 N3621SAlletto Alexander J · Russell Springs, KYBuilt 1964 · S/N 17250821 N3621UStewart Gary T · Friendswood, TXBuilt 1963 · S/N 18255021 N3621YRegistered aircraftBuilt 1963 · S/N 21058121 N3622LStrelzik Raymond W · Hatfield, PABuilt 1965 · S/N 17253791 N3622SMichael Lewis R · Big Rapids, MIS/N 17250822 N3622UDegonia Gerald · Plainfield, ILBuilt 1963 · S/N 18255022 N3622VFox John E · Boonville, CABuilt 1975 · S/N 15076565 N3623VClark Cecil L · Shreveport, LABuilt 1975 · S/N 15076566 N3624CMeadows Marcus M · Anchorage, AKBuilt 1954 · S/N 31122 N3624UWilkinson Larry G · Henderson, NVBuilt 1963 · S/N 18255024 N3625LWilliams Michael R · Gig Harbor, WABuilt 1965 · S/N 17253794

Back to AD 79-10-14 R1