Skip to content

Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N758JGMorton Frank W · Harwinton, CTBuilt 1979 · S/N R1723128 N758JRTownsend Robert J · Leavenworth, WABuilt 1979 · S/N R1723137 N758JSHenderson Scott · Tucson, AZBuilt 1979 · S/N R1723138 N758JTEdwards Thomas G Trustee · Jacksonville, ORBuilt 1979 · S/N R1723139 N758JZReaka Dean James Trustee · Troy, MOBuilt 1979 · S/N R1723145 N758KCMccormick Robert C · Vlg Of Lakewd, ILBuilt 1979 · S/N R1723148 N758KFMorgan Kenneth J · Norridgewock, MEBuilt 1979 · S/N R1723151 N758KMStrong Janet L · Vancouver, WABuilt 1979 · S/N R1723157 N758KRKairys Steven A · Encino, CABuilt 1979 · S/N R1723161 N758KVAk Denali Group LLC · Anchorage, AKBuilt 1979 · S/N R1723165 N758LCDepino Damian P · Dummerston, VTBuilt 1979 · S/N R1723172 N758LEBernheim Karen M · Sisters, ORBuilt 1979 · S/N R1723174 N758LJPeery William R · Beckley, WVBuilt 1979 · S/N R1723178 N758LMSwenson Karine · Anchorage, AKBuilt 1979 · S/N R1723181 N758LNLittle 8 Mile Ranch LLC · Missoula, MTBuilt 1979 · S/N R1723182 N758LPTony Joe Aviation LLC · Sheridan, WYBuilt 1979 · S/N R1723183 N758LRWood Tyler J · Creston, CABuilt 1979 · S/N R1723185 N758LSKomizo Enterprises LLC · Fort Worth, TXS/N R1723186 N758LWTeton Leasing LLC · Pocatello, IDBuilt 1979 · S/N R1723190 N758LYDixon Craig S · Rimrock, AZBuilt 1979 · S/N R1723192 N758MHFantasy Flyer LLC · Ojai, CABuilt 1979 · S/N R1723201 N758MLStrong Ronald E · Phoenix, AZS/N R1723204 N758MNTritt Scott W · Bolivar, OHBuilt 1979 · S/N R1723206 N758MPPickle Brad R · Pottsboro, TXBuilt 1979 · S/N R1723207 N758MQSarkissian Hovannes · Pasadena, CABuilt 1979 · S/N R1723208 N758MSRegistered aircraftBuilt 1979 · S/N R1723210 N758MTTurbine Financial Group LLC · Ogden, UTBuilt 1979 · S/N R1723211 N758MVCarson Flying Feeders LLC · Carson, IABuilt 1979 · S/N R1723213 N758MWHaddock Debra E · Shelby, NCBuilt 1979 · S/N R1723214 N758MYMcclellan Steven D · Blackfoot, IDBuilt 1979 · S/N R1723216 N758MZMowry Valetta J · Greensburg, PABuilt 1979 · S/N R1723217 N758NAManabe Osamu · Kapolei, HIBuilt 1979 · S/N R1723218 N758NBMcdonald Sporting Goods · Murfreesboro, TNBuilt 1979 · S/N R1723219 N758NCWatkins Herbert L Jr · Durango, COS/N R1723220 N758NDPlatinum Hawk Xp LLC · Flower Mound, TXS/N R1723221 N758NFBoeing Employees Flying Association · Renton, WABuilt 1979 · S/N R1723223 N758NJNoble Investments LLC · Naples, FLBuilt 1979 · S/N R1723226 N758NLDc Aero LLC · Ramona, CABuilt 1979 · S/N R1723228 N758NVKirk Blackstone LLC · Las Vegas, NVBuilt 1979 · S/N R1723237 N758NYHall Associates LLC · Homer, AKS/N R1723240 N758PANew Horizons Aviation Inc · Goshen, INBuilt 1978 · S/N 15282932 N758PDWilliams Gary L · Hastings, NEBuilt 1979 · S/N R1723244 N758PEHeise Jeffrey A · Fishers, INS/N R1723245 N758PHFarguson David M · Pasadena, CAS/N R1723248 N758PKSkyking Aviation LLC · Obion, TNBuilt 1979 · S/N R1723250 N758PNColorado Northwestern Community College · Rangely, COS/N R1723253 N758PTTkj Equipment LLC · El Dorado Hills, CABuilt 1979 · S/N R1723258 N758PVLuck Richard S · Superior, WIS/N R1723260 N758PXWiley'S Little Red Wagon LLC · Osseo, MNBuilt 1979 · S/N R1723262 N758PZSt Matthew Aero LLC · Kalispell, MTBuilt 1979 · S/N R1723264

Back to AD 87-20-03 R2