Skip to content

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.

N4826TSundance Air Services Inc · Alameda, CAS/N 28-7205202 N4827LDes Moines Flying Club · Indianola, IABuilt 1967 · S/N 28-4170 N4828LMcmordie Frank F IV · Dallas, TXBuilt 1967 · S/N 28-4171 N4828TSun Star Holdings LLC · Binghamton, NYBuilt 1972 · S/N 28-7205203 N4829GSoaring Raven LLC · Seattle, WABuilt 1979 · S/N 17273377 N4829LHoughton Robert E · North Ferrisburgh, VTBuilt 1967 · S/N 28-4172 N4829TMaples David R · Diamondhead, MSS/N 28-7205204 N482ACClarke Jonathan Eric · Eustace, TXBuilt 1999 · S/N 428-99 N482AMWarner Robins Air Service · Cochran, GABuilt 2004 · S/N 2282 N482ASPlatt Drey D · Sahuarita, AZBuilt 1968 · S/N 28-25252 N482CCMitchell Timothy K · Dunnellon, FLBuilt 1967 · S/N 28-4165 N482DTCavorite Aviation LLC · Lehi, UTS/N 28-8490071 N482EHb Coco & Company · Gonzales, TXBuilt 1979 · S/N 17272338 N482EJDavis Douglas L · Everson, WABuilt 1953 · S/N 20-1052 N482FLJacobs Mark W · Browning, MTBuilt 1971 · S/N 28-7125288 N4830ARenick Tyler Cain · Wichita Falls, TXS/N 22-3983 N4830FRitzman Todd F · Pewaukee, WIBuilt 1976 · S/N 28-7725031 N4830GHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1979 · S/N 17273378 N4830LOne Niner Right Ltd · Bartlett, ILBuilt 1967 · S/N 28-4173 N4830UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842236 N4831LMartinez Custom Homes LLC · Porter, TXBuilt 1967 · S/N 28-4174 N4832ESenn David L · Oak Ridge, TNBuilt 1959 · S/N 7GC-40 N4833LAdbm LLC · Oldsmar, FLBuilt 1967 · S/N 28-4176 N4834ARegistration Pending · Eagle River, WIRegistration pendingBuilt 1956 · S/N 22-3987 N4834ESweeney Michael J · Seattle, WABuilt 1978 · S/N 17271670 N4834LBell Hubert D · Lewiston, IDBuilt 1967 · S/N 28-4178 N4835GFiedler Aviation LLC · Suffolk, VABuilt 1979 · S/N 17273383 N4835LSims Kyle Z · Locust Grove, GAS/N 28-4179 N4835TPero Thomas E · Richland, MIBuilt 1972 · S/N 28-7225218 N4836ASales Joe Haney · Seminole, TXS/N 22-3989 N4836GEvolo Aviation LLC · Worthington, OHBuilt 1979 · S/N 17273384 N4836LPeterson Wayne · Dexter, MNBuilt 1967 · S/N 28-4180 N4837FWesellairplanes Com Inc · Wilmington, DEBuilt 1976 · S/N 28-7715071 N4837LNavarro Ricky L · Riverview, FLBuilt 1967 · S/N 28-4181 N4838Fajardo Mark A · Longmont, COBuilt 1975 · S/N KB-1 N4838FThomason Booker T Jr · Chicago, ILBuilt 1976 · S/N 28-7715072 N4838LSandstrom David E · Anchorage, AKBuilt 1967 · S/N 28-4182 N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386 N4839LStandard David W · Toccoa, GABuilt 1967 · S/N 28-4183 N4839WPiscoya Thomas G · Anchorage, AKBuilt 1989 · S/N 1809012 N483ACTessos Air Service Inc · Wilmington, DEBuilt 1999 · S/N 1282-99 N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688 N483FLOliver Zachary J · Seligman, AZBuilt 1971 · S/N 28-7125291 N4840LIrons Eric P · Enoch, UTBuilt 1967 · S/N 28-4186 N4841DDoorglobe Inc · San Francisco, CABuilt 1979 · S/N 17272371 N4841FVidhun Raghuraman R · Southbury, CTBuilt 1976 · S/N 28-7790067 N4841LPapa India Echo Inc · Chambersburg, PABuilt 1967 · S/N 28-4187 N4842AHill Steven Douglas · Stoneville, NCBuilt 1956 · S/N 22-3995 N4842THampsten Jacob Clay · Mesquite, NVS/N 28-7225222 N4843ANous Air LLC · Yukon, OKBuilt 1956 · S/N 22-3996

Back to AD 79-10-03 R2