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

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.

N13849Durkee Robert J · Prineville, ORBuilt 1974 · S/N 17263021 N1384CRedwood Area Flyers LLC · Redwood Falls, MNBuilt 1977 · S/N 17702719 N1384LCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1978 · S/N 33701876 N1384SAdventure Aviation LLC · Fresno, CABuilt 1976 · S/N 18264946 N1385FRautio Ian · Intl Falls, MNS/N 17254880 N1385LWhiskey River Aviation LLC · Medford, ORBuilt 1978 · S/N 33701877 N1385MPecha James C · Binghamton, NYBuilt 1975 · S/N 18264307 N1385QRegister Trenton D · Wilmington, NCBuilt 1971 · S/N 15072685 N1385YCaracci Sam V Jr · Galesburg, ILS/N 17249085 N1386DDeford Shawn J · Hope, AKBuilt 1951 · S/N 20109 N1386EWitsoe Kathleen · Knoxville, TNBuilt 1982 · S/N 18268176 N1386MJohnson Shannon L · Granite Falls, MNBuilt 1971 · S/N 18260826 N1386QRegistration Pending · Wasilla, AKRegistration pendingBuilt 1971 · S/N 15072686 N1386SLangel Joseph J · Lakeville, MNBuilt 1976 · S/N 18264947 N13874Missionair LLC · Livingston, NYBuilt 1974 · S/N 17263026 N1387FEllis Jerald K · Fort Myers, FLBuilt 1966 · S/N 17254882 N1387MJ&D Aero LLC · Wilmington, DEBuilt 1975 · S/N 18264308 N1387QHendricks Adam · Plano, TXBuilt 1971 · S/N 15072687 N1387SGalaz Nick Anthony · Lake Havasu City, AZBuilt 1976 · S/N 18264948 N1387UCp Aircraft Leasing LLC · Danville, CABuilt 1976 · S/N 17267058 N1387YBi-County Ambulance Service Inc · Yuba City, CABuilt 1961 · S/N 17249087 N13884Triple F Aviation LLC · Scott City, KSS/N 17263028 N13887Jkg LLC · Murfreesboro, TNBuilt 1974 · S/N 17263029 N13889Carver Brian J · Rockwell City, IABuilt 1974 · S/N 17263030 N1388DGroceman Bernard F · Jackson, MOBuilt 1951 · S/N 19964 N1388SCowboy Taxi LLC · Payson, AZBuilt 1976 · S/N 18264949 N1388UBeining Grant P · Fullerton, CABuilt 1976 · S/N 17267059 N13890Registration Pending · Commerce, GARegistration pendingBuilt 1974 · S/N 17263031 N13892Meyers Alexander C · Pittsburgh, PABuilt 1976 · S/N 17702475 N1389FBedford Aero Club Inc · Bedford, INS/N 17254884 N138FRAyotte Matthew A · South Haven, MIBuilt 1986 · S/N 17276545 N138JPChang Denny · Easton, PABuilt 1970 · S/N 17701442 N138MEA&R Aero LLC · Sacramento, CABuilt 2000 · S/N 172S8422 N138RCBardin G W · Granville, NYBuilt 1976 · S/N 177RG0994 N138SWQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 18265569 N138UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11487 N138WWCutler Christopher P · Whitewright, TXBuilt 1954 · S/N 26189 N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035 N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036 N1390LGreen Rose LLC · Swartz Creek, MIBuilt 1978 · S/N 33701882 N1390YMarshall Greg J · Alexandria, VABuilt 1961 · S/N 17249090 N1391QPark Derek B · Lyons, GABuilt 1971 · S/N 15072691 N1391SWysong Charles J · Hickory, NCFirst renewal noticeBuilt 1976 · S/N 18264952 N1391UArctic Winds Inc · King Salmon, AKS/N 17267062 N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039 N1392DChalender Robert Christopher · Cocoa, FLS/N 19968 N1392QRegistered aircraftBuilt 1971 · S/N 15072692 N1392SAbc Flying Club Inc · West Mifflin, PABuilt 1976 · S/N 18264953 N1392YDoty Douglas C · The Dalles, ORBuilt 1961 · S/N 17249092 N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041

Back to AD 79-10-14 R1