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.

N3947YRafter Jm Enterprises LLC · Swink, OKBuilt 1964 · S/N 21058447 N3948QCitabria Inc · Auburn, CABuilt 1971 · S/N 17260048 N3948SDykstra Johnny R · Sioux Falls, SDBuilt 1964 · S/N 17251148 N3948UHolloway Earnie G · Bonner Springs, KSBuilt 1965 · S/N 15061348 N3948VKlein Jordan Jr · Summerfield, FLS/N 18267 N3948YSwine Management Service Inc · Long Island, KSBuilt 1964 · S/N 21058448 N3949FReed Systems Ltd · Ellenville, NYBuilt 1958 · S/N 36849 N3949QTuschen James E · Rockford, ILBuilt 1971 · S/N 17260049 N3949RLacroix Paul R · Taylor, MIBuilt 1966 · S/N 17255449 N3949SColler Sauntee C · Kadoka, SDBuilt 1964 · S/N 17251149 N3949VShort Thomas · Noblesville, INBuilt 1948 · S/N 18268 N394CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13103 N394CVBas Part Sales LLC · Greeley, COBuilt 2016 · S/N 18282437 N394RAN Registration Service LLC Trustee · Sanford, NCS/N 21059329 N394SPEdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8291 N39501Registration Pending · Phoenix, AZRegistration pendingBuilt 1982 · S/N U206-06452 N3950FSeifert Justin R · Minot, NDBuilt 1958 · S/N 36850 N3950QDieter Jason W · Midlothian, VAS/N 17260050 N3950RJung Christopher M · Anchorage, AKS/N 47424 N3950SBlue Sky Aviation Adventures LLC · St George, UTS/N 17251150 N3950VPartridge Leslie R · Spicewood, TXS/N 18269 N3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1964 · S/N 21058450 N3951JJenani Industries LLC · La Verne, CABuilt 1966 · S/N 15065251 N3951QGarcia Larry M · Garden Valley, CABuilt 1971 · S/N 17260051 N3951VBrosh Donald R · Centennial, COBuilt 1948 · S/N 18376 N3951YRodriguez Coppola Patricio Andres · New Orleans, LABuilt 1964 · S/N 21058451 N3952JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1966 · S/N 15065252 N3952QLloyds 172 LLC · Moore, OKS/N 17260052 N3952STorres Jeremy · Cranston, RIBuilt 1964 · S/N 17251152 N3953FRegistration Pending · Plainfield, NJRegistration pendingBuilt 1958 · S/N 36853 N3953JKearns Reno T · Jeannette, PAS/N 15065253 N3953PSowards David C · Fairbanks, AKBuilt 1976 · S/N 18503090 N3953QQueen Anne Air LLC · Seattle, WAS/N 18503422 N3953SLex Air LLC · Corona, CABuilt 1964 · S/N 17251153 N3954FGossom J Burk · Friday Harbor, WABuilt 1958 · S/N 36854 N3954JDroessler Anthony E · Lakota, IABuilt 1966 · S/N 15065254 N3954SCochran Kevin R Trustee · Dayton, OHBuilt 1964 · S/N 17251154 N3954UQuon Nicholas · Fayetteville, GABuilt 1965 · S/N 15061354 N3954VMoyer Michael · Duarte, CABuilt 1948 · S/N 18273 N3954YStone Clifford F Jr · Corning, CABuilt 1964 · S/N 21058454 N3955FSpringfield Flying Service LLC · Columbia, CABuilt 1958 · S/N 36855 N3955JLaird Charles L · Adelanto, CABuilt 1966 · S/N 15065255 N3955LLukasik Jason D · Eagle River, AKBuilt 1966 · S/N 17254124 N3955SZilz Tammy S · Saint Peters, MOBuilt 1964 · S/N 17251155 N3956DJohnson Justin R · Bonners Ferry, IDS/N 34656 N3956JStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 15065256 N3956SEndsley Terry G · Wilkeson, WAS/N 17251156 N3956VBell Robert D · Okeechobee, FLS/N 18275 N3956YWilliams John S · Fort Walton Beach, FLBuilt 1964 · S/N 21058456 N3957JMckinnon Benjamin G · Santaquin, UTS/N 15065257

Back to AD 79-10-14 R1