Registered aircraft · 40,396

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N516PCSpace Coast Aircraft Co · Merritt Island, FLBuilt 2002 · S/N 2842150 N516PUAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1983 · S/N 28-8316101 N516RVFoster Todd H · Long Beach, CABuilt 2003 · S/N 23393 N516SCThomason Scott D · Greer, SCBuilt 2001 · S/N 5098 N516TGNatchez Flight Training LLC · Natchez, MSBuilt 1977 · S/N 17268889 N51700Brown County Flying Club · Aberdeen, SDBuilt 1980 · S/N 17274338 N5170MWheeler David A · York, PABuilt 1978 · S/N M-2050 N5170PBosch Christopher J · Bloomington, MNBuilt 1958 · S/N 24-188 N5171HPan Air Flying Club · Miami, FLBuilt 1975 · S/N 17265358 N5171KBrewer Curtis E · Millington, TNBuilt 1980 · S/N 17273998 N5171LCrum Clarence F · West Salem, OHBuilt 1967 · S/N 28-4457 N5171RSamuels Jay M · East Tawas, MIBuilt 1974 · S/N 17263388 N5171USummers Jeffrey L · Pekin, INBuilt 1980 · S/N 172RG0272 N5171WPeters W Benny · Garden City, KSS/N 28-202 N5172HMsi Fuel Management Inc · Vacaville, CABuilt 1975 · S/N 17265359 N5173LDevries Pat DBA · Germansville, PABuilt 1967 · S/N 28-3994 N5173PColorado Aviation Group LLC · Colorado Springs, COS/N 24-192 N5173SDamore Joseph · Ingleside, ILBuilt 1970 · S/N 28-7105027 N51748Planenutz LLC · Deland, FLBuilt 1980 · S/N 17274342 N5174AWells Lavar W · Hanksville, UTBuilt 1956 · S/N 28174 N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752 N5174HFlying Finn Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 17265360 N5174LVentura Robert E · Ventura, CAS/N 28-4459 N5174SKatzakian Trevor T · Lodi, CABuilt 1970 · S/N 28-7105028 N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753 N5175SBlu Skye Distribution Inc · Mount Holly, NCBuilt 1970 · S/N 28-7105029 N5175TMcclain Timothy J · Tucson, AZBuilt 1966 · S/N 147 N5176HBoyer Christopher A · Anchorage, AKBuilt 1948 · S/N 14-196 N5176LMilliner Greg A · Kokomo, INBuilt 1967 · S/N 28-4462 N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044 N5176SNora Jet LLC · Granbury, TXS/N 28-7105030 N5176TScott Judson M · Wasilla, AKBuilt 1967 · S/N 153 N5176VVangorder Donna · Greenwood, ARS/N 172RG0459 N5177FPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715096 N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361 N5177PLi Steven Y · Warren, NJBuilt 1958 · S/N 24-197 N5177WBuffham Daniel L · Meridian, IDBuilt 1961 · S/N 28-212 N5178AHale Mitchell D · Chugiak, AKBuilt 1962 · S/N 18-7483 N5178HGage Scott M · Anchorage, AKS/N 14-200 N5178LMinick And Son LLC · Beatrice, NEBuilt 1967 · S/N 28-4464 N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395 N5178WMahoney Christopher P · Quakertown, PABuilt 1961 · S/N 28-213 N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347 N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362 N5179PHangar 17 LLC · Sheridan, WYBuilt 1958 · S/N 24-199 N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460 N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965 N517GSPtag Flight Service LLC · Vidalia, GABuilt 1996 · S/N 2996 N517JGollus Daniel T · Lockport, NYBuilt 1997 · S/N 22753 N517JCProfessional Pilot Services · Appleton, WIBuilt 1971 · S/N 28-7125098

Back to AD 79-10-03 R2