Skip to content

Registered aircraft · 18,495

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N761CECharlie Echo Enterprises LLC · Cedar Hills, UTBuilt 1977 · S/N 21062143 N761CLUlrick Michael R · Spokane, WABuilt 1977 · S/N 21062149 N761CNFrance Sherrod W Trustee · Rawlins, WYBuilt 1977 · S/N 21062151 N761CTNajm Ziad · Mission Viejo, CABuilt 1977 · S/N 21062156 N761CWOne Charlie Whiskey LLC · Austin, TXBuilt 1980 · S/N 21064042 N761DHSk Sky LLC · Clint, TXBuilt 1977 · S/N 21062170 N761DLTyler David W · Glendale, AZBuilt 1977 · S/N 21062173 N761DMHudson William B L · Belvedere, CABuilt 1977 · S/N 21062174 N761DNReichman Robert T Trustee · Escondido, CABuilt 1977 · S/N 21062175 N761DPSunset Cattle Co LLC · Los Banos, CABuilt 1977 · S/N 21062176 N761DSTroutman Alan D · Springtown, PABuilt 1977 · S/N 21062179 N761DXFlying Float Club LLC · Tavares, FLBuilt 1977 · S/N 21062184 N761EPAndrew R Jodway · New Port Richey, FLBuilt 1977 · S/N 21062200 N761EUMelvey Jay R · Westminster, COBuilt 1977 · S/N 21062205 N761EWInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 21062207 N761EXCarolina Crafted Construction LLC · Greenville, SCBuilt 1977 · S/N 21062208 N761EZState Of Arizona · Prescott, AZBuilt 1977 · S/N 21062210 N761FBVitatoe Industries Inc · Chillicothe, OHBuilt 1977 · S/N 21062212 N761FCFrenchman Valley Produce Inc · Imperial, NEBuilt 1977 · S/N 21062213 N761FHBar W Assets LLC · Elberta, ALBuilt 1977 · S/N 21062218 N761FKSunset Cattle Co LLC · Los Banos, CABuilt 1977 · S/N 21062220 N761FQBalderrama Rocio Ovando · El Paso, TXBuilt 1977 · S/N 21062225 N761GBFerguson Robert Martin Todd · Carlisle, ARBuilt 1977 · S/N 21062236 N761GDRiesa Construction LLC · Herman, NEBuilt 1977 · S/N 21062238 N761GETeton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 21062239 N761GN21 - 55 Aviation LLC · Pella, IABuilt 1977 · S/N 21062247 N761GYOff We Go LLC · Fort Collins, COBuilt 1977 · S/N 21062257 N761HCZimmermann Fredric M · Granbury, TXBuilt 1977 · S/N 21062261 N761HEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 21062263 N761HNA-1 American Fence Inc · Orange, TXBuilt 1977 · S/N 21062271 N761HSLassetair LLC · Glen Ellen, CABuilt 1977 · S/N 21062275 N761HTWieckowski Peter · Boxford, MABuilt 1977 · S/N 21062276 N761HVResultant Aviation LLC · Orlando, FLBuilt 1977 · S/N 21062278 N761JBSchwechten Physician Services Pllc · New Waverly, TXBuilt 1969 · S/N E-163 N761JDRj Aviation LLC · Byhalia, MSBuilt 1977 · S/N 21062286 N761JK926-928 Newton LLC · Denver, COS/N 21062292 N761JMFour Star Ranch Inc · Randlett, UTS/N 21062294 N761JTStahlberg Jeffrey C · Blissfield, MIBuilt 1967 · S/N CE-153 N761KBOne Kilo Bravo · Renton, WABuilt 1977 · S/N 21062307 N761KEDownstown Airport Inc · Vineland, NJBuilt 1977 · S/N 21062310 N761KLBranson William E · Stokesdale, NCBuilt 1977 · S/N 21062316 N761KVDiamond X Aviation LLC · Johnson City, TXBuilt 1977 · S/N 21062325 N761LBDiamond 210 LLC · Dover, DEBuilt 1977 · S/N 21062331 N761LGTrinkle Aviation LLC · Kingsburg, CAS/N 21062336 N761LMDyer J Scott · Pleasantville, NYBuilt 1977 · S/N 21062341 N761LQFlying Pharaohs LLC · Fredericksburg, VABuilt 1977 · S/N 21062344 N761LTFiddelman Joseph D · Port Orange, FLBuilt 1978 · S/N D-10187 N761LUStowell Robert W · La Porte, INBuilt 1977 · S/N 21062348 N761LYHigh Flying Texans LLC · Arlington, TXS/N 21062352 N761MBGump Timothy K · Dalton Gardens, IDBuilt 1977 · S/N 21062354

Back to AD 86-13-04 R3