Registered aircraft · 56,572

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.

N101GHSan Diego Community College District · San Diego, CAS/N 18260875 N101GVWindward West Inc · Boise, IDBuilt 1998 · S/N 172S8021 N101JHHi-Per Aviation Inc · Arroyo Grande, CABuilt 1972 · S/N 21059759 N101KSWright Kenneth D · Benton, ARBuilt 1974 · S/N 17263095 N101KTBryan Jerry E · Kathleen, GABuilt 1978 · S/N 18266264 N101LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13119 N101LJGrenier Garret P · Anchorage, AKBuilt 1976 · S/N 17267273 N101LULynn University Inc · Boca Raton, FLBuilt 1999 · S/N 17280709 N101MBGearin Chad T · Portland, ORBuilt 1960 · S/N 56537 N101MJRose Daniel · Cold Spring, NYBuilt 1974 · S/N A1500528 N101MTAllman Air LLC · Blackstone, VABuilt 1969 · S/N P20600626 N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932 N101RGTree Air LLC · Vero Beach, FLBuilt 1967 · S/N 18258526 N101RKBlake James R · Marion, LABuilt 1972 · S/N 17261166 N101SPHawkes Clark · Gillsville, GABuilt 1986 · S/N 18268562 N101TCTcm Flying Club Inc · Mobile, ALBuilt 1968 · S/N 18259330 N101TFAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12710 N101USUsaeroflight LLC · Greenville, SCBuilt 1972 · S/N 17260922 N101UTRudd James M · Lake Jackson, TXBuilt 1971 · S/N 17259900 N101VBRegistered aircraftBuilt 1999 · S/N 18280438 N101VKWings Over Texas Holdings LLC · Denton, TXBuilt 1999 · S/N 172S8211 N101WLRegistration Pending · Wichita, KSRegistration pendingBuilt 2026 · S/N 172S13568 N101WPScc Associates Ltd · Wilmington, DEBuilt 1975 · S/N 18264220 N101WSKarnick Mark C · Mesa, AZBuilt 1971 · S/N 17260218 N10205Thorndal John J · Tucson, AZBuilt 1973 · S/N 15074818 N10207Sillinger Daniel E · Covington, LABuilt 1973 · S/N 15074819 N10208Ekstrum Eric · Mound House, NVBuilt 1973 · S/N 15074820 N1020MWinner Philip · Houston, TXBuilt 1975 · S/N 18264208 N1020UNorth Central Aircraft Sales · Tioga, NDS/N 18783 N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404 N10213Sparks Tom · Palestine, ILBuilt 1975 · S/N 17702317 N1021CRiener Clinton G · Cottonwood, IDBuilt 1966 · S/N 18257409 N1021MMcconnell Frank V Jr · Woodstock, GABuilt 1969 · S/N 15070991 N1022FGoodfellow Malcolm D · Seattle, WABuilt 1975 · S/N 18502690 N1022MHilton David L · Shreveport, LABuilt 1975 · S/N 18264209 N1023BLeguia Augusto A · Kathleen, GAS/N 28524 N1023FWinter Karl · Litchfield Park, AZBuilt 1975 · S/N 18502691 N1024Calgonaire LLC · Seminole, TXS/N 57425 N10242Alexander Holding Services Inc · Newark, DEBuilt 1972 · S/N 21059704 N1024MEdwards Chris R · Meadow Vista, CABuilt 1975 · S/N 18264210 N10255Zook Lester R · North East, PABuilt 1973 · S/N 15074825 N1025MSupina Robert P · Richmond, TXBuilt 1975 · S/N 18264211 N1025VAviation Partners LLC · Highlands Ranch, COBuilt 1976 · S/N R1722086 N1026MStinar Gary F · Lakeville, MNBuilt 1970 · S/N 17259406 N1027MLoomis Aviation LLC · Gahanna, OHBuilt 1970 · S/N 17259407 N1027XHarper Shawn · Bayfield, COBuilt 1954 · S/N 31205 N1028FLunoe Leif C · Anchorage, AKBuilt 1975 · S/N 18502695 N1028MWenz Michael D · Gillette, WYBuilt 1975 · S/N 18264212 N10297Landis Robert T · Laredo, TXS/N 15074831 N102ACWindfall Capital Ventures LLC · Westerville, OHS/N 17271882

Back to AD 79-10-14 R1