Skip to content

Registered aircraft · 40,394

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.

N7485WBond Jesse · Pulaski, TNS/N 28-1395 N74864Defenbaugh Matthew J · Biggsville, ILBuilt 2005 · S/N 3997 N74865Welch William R Jr · Baton Rouge, LABuilt 1976 · S/N AA5B0388 N74867Carr Thomas J · Overland Park, KSBuilt 1976 · S/N AA5B0391 N7486WBaney David · Summitville, INBuilt 1963 · S/N 28-1396 N74870H O S Aviation LLC · Mount Pleasant, SCBuilt 1976 · S/N AA5B-0270 N74875Thomas Martin G · Tucson, AZBuilt 1976 · S/N AA5B-0271 N74877Hopkinson Keith G · Spicewood, TXBuilt 1976 · S/N AA5B-0272 N74878Stiles Steven A Trustee · Pebble Beach, CABuilt 1976 · S/N AA5B-0273 N7487DSouthern Cross Aviation Inc · Wilmington, DEBuilt 1957 · S/N 18-5826 N7487GRich Aviation Services LLC · Fort Worth, TXBuilt 1970 · S/N 17259187 N7487KMesones Juan D · North Yarmouth, MEBuilt 1950 · S/N 20-401 N7487RDeschamp Patrick B · Bottineau, NDS/N 28-22040 N74881Rockwood Holdings LLC · Valrico, FLBuilt 1976 · S/N AA5B-0274 N74882Huntley David · San Antonio, TXBuilt 1976 · S/N AA5B-0276 N74884Switek Robert E Jr Trustee · San Andreas, CABuilt 1976 · S/N AA5B-0278 N74886Fisher Robert W · Madison, ALBuilt 1976 · S/N AA5B-0280 N74889Unlimited Aviation LLC · Webster, NYBuilt 1967 · S/N 28-4519 N7488DDust Devil Herefords Inc · Ingomar, MTBuilt 1957 · S/N 18-5827 N7488RSimpson Kevin B · Newberg, ORBuilt 1966 · S/N 28-22042 N7488WAnuradha Jairam · Camas, WABuilt 1963 · S/N 28-1399 N7489DKelly Kevin M · Eagle River, AKBuilt 1957 · S/N 18-5828 N7489GCloud Fleet Aviation LLC · Fort Lauderdale, FLBuilt 1970 · S/N 17259189 N7489LMills Randall J · Monroe, MIBuilt 1975 · S/N 18-7509076 N7489WHostetler Kevin · Green Forest, ARBuilt 1963 · S/N 28-1400 N748HHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1748 N748RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1988 · S/N 2841035 N748RSGrady Michael J · Farmington, NMBuilt 1968 · S/N 28-5230 N748SBright Skies Sales And Leasing LLC · Hendersonville, TNS/N 1728 N7490WCome Fly With Me LLC · Columbiana, ALBuilt 1963 · S/N 28-1401 N74912Sky Sailing Inc · Warner Springs, CABuilt 1975 · S/N 18-7509094 N74913Street Raymond E Jr Trustee · Fort Worth, TXBuilt 1975 · S/N 18-7509095 N74919Braden John H · Watseka, ILBuilt 1975 · S/N 18-7509096 N7491GAccess Air Service Inc · Mercedita, PRBuilt 1970 · S/N 17259191 N7491WWillard Michael W · Boonville, NCS/N 28-1402 N74922Sale Reported · Anchorage, AKSale reportedBuilt 1975 · S/N 18-7509097 N74924Rs Specialties LLC · Anchorage, AKBuilt 1975 · S/N 18-7509098 N74929Shadbolt George Q · Merriman, NES/N 18-7509101 N7492WN7492w LLC · Spicewood, TXBuilt 1963 · S/N 28-1405 N74935Mcevoy Richard D Trustee · Anchorage, AKBuilt 1975 · S/N 18-7509100 N7493GHaugo Robert P · Scobey, MTBuilt 1970 · S/N 17259193 N7493RWalcher James W · Wilmington, ILBuilt 1966 · S/N 28-22047 N7493WNonn Lidia G · Appleton, WIBuilt 1965 · S/N 28-2900 N74945Wright Sherry L · Buhl, IDBuilt 1975 · S/N 18-7509102 N7494WLandreth Homer W · Peoria, AZBuilt 1963 · S/N 28-1407 N7494YRay James O III · Mc Rae, GABuilt 1964 · S/N 30-555 N74954Willis Andrew B · Wasilla, AKBuilt 1975 · S/N 18-7509103 N74960Smith Wallace B · Fairbanks, AKBuilt 1975 · S/N 18-7509105 N74964Air Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18-7509104 N74967Owens Sara R · Casper, WYS/N 18-7509107

Back to AD 79-10-03 R2