Skip to content

Registered aircraft · 6,916

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

N8158YRobert Lea Investments LLC · Molalla, ORBuilt 1980 · S/N 32-8024006 N8159SGaither David G Executor · Houston, TXS/N 32R-8029059 N8159YRaven Aviation LLC · Murrayville, GABuilt 1980 · S/N 32R-8029060 N815TAS3 Air Aviation LLC · Henderson, NVBuilt 1976 · S/N 32R-7680356 N8165JLloyd J Cleaver D O LLC · Kirksville, MOBuilt 1980 · S/N 32-8024010 N8165RLord David A DBA · Mackay, IDFirst renewal noticeBuilt 1980 · S/N 32R-8029063 N8167DBurch Robert S · Tyler, TXBuilt 1980 · S/N 32R-8029049 N8169ZHarper Hugh Holdings LLC · Alvarado, TXBuilt 1980 · S/N 32-8024012 N816ARCustom Curb Inc · Ventura, CABuilt 2005 · S/N T18208451 N816GHolland Travel Air LLC · Holmen, WIBuilt 1964 · S/N TD-562 N816JGPie Haven LLC · Fort Lauderdale, FLBuilt 2016 · S/N 4636696 N816NHSteinwedel Norbert · Cornelius, NCS/N A-821 N816PTPrudence Aviation Group · Fort Worth, TXBuilt 2020 · S/N T20609604 N816TPDefense Research Institute Inc · Fayetteville, NCBuilt 2012 · S/N 4636529 N816YPB&D Air Solutions LLC · Austin, TXBuilt 1978 · S/N 32R-7885267 N8170SSkywagons.Com LLC · Placerville, CAS/N 32R-8029067 N8171WAnderson Christopher J · Ogden, UTBuilt 1965 · S/N 28-2291 N8172PWison Keene · Abbeville, GABuilt 1981 · S/N 32R-8129028 N8173PLao Investments LLC · Meeker, COBuilt 1980 · S/N 32-8024015 N8177YElite Approach LLC · Chesterfield, MOBuilt 1982 · S/N 32R-8229042 N817MJSmt Services LLC · Archie, MOBuilt 2016 · S/N 4636700 N817TRRobinson Trent · Havana, FLBuilt 2000 · S/N 3257132 N8180DBobert Bunny LLC · Wilmington, DEBuilt 1980 · S/N 32R-8029075 N8180FTag International Corporation Inc · Sheridan, WYBuilt 1980 · S/N 32R-8029076 N8182TMesa Aviation LLC · Brookings, SDBuilt 2018 · S/N T20609549 N8185CKirkland Kerry G · Spring, TXBuilt 1975 · S/N 32-7640053 N8185WAlaska Media LLC · Anchorage, AKBuilt 1980 · S/N 328024017 N8185YCarter Gregory A · Edmonds, WABuilt 1980 · S/N 32-8024018 N8186FN8186f Inc · Danville, INBuilt 1976 · S/N 32R-7780088 N8187PKlein Dale A · Mandan, NDBuilt 1963 · S/N 24-3443 N8188MSmith Jeffrey E · Dunedin, FLBuilt 1982 · S/N 32R-8229043 N8188TPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 32R-8029081 N818AHChandler Jerome P · Redondo Beach, CABuilt 1973 · S/N 32-7340126 N818CCFlyit LLC · Camas, WAS/N 27-2977 N818DUPrescott John E Jr · Tempe, AZBuilt 2004 · S/N T18208313 N818KARno Flyers LLC · Reno, NVBuilt 2012 · S/N T18209086 N818SMMainardi William · Lincoln Park, NJBuilt 2007 · S/N T18208789 N818TECentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-995-26 N818TSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609841 N8191HPorter John W · Center, TXBuilt 1980 · S/N 32R-8029085 N8192QSunshine Industries Inc · Abingdon, VABuilt 1980 · S/N 32-8024020 N8193NNorthstar Air LLC · Tempe, AZBuilt 1980 · S/N 32-8024021 N8193PFlying Crooner LLC · Orlando, FLBuilt 1963 · S/N 24-3449 N8194EBill W Chu Inc · Madera, CABuilt 1980 · S/N 32-8024024 N8196PWorkman Randy · Tipp City, OHBuilt 1963 · S/N 24-3270 N8197HFour Dudes Flying LLC · Cabot, ARBuilt 1982 · S/N 32R-8229045 N8197LGcg Aviation LLC · Fayetteville, GAS/N 32R-8229047 N8197PThrash St LLC · Lubbock, TXBuilt 1983 · S/N 32-8324002 N8197WRegistration Pending · Rifle, CORegistration pendingBuilt 1980 · S/N 32R-8029050 N819CWietbrock Douglas F · San Antonio, TXBuilt 2006 · S/N 3255049

Back to AD 71-13-01 R1